Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÓÃADO²Ù×÷MYSQLÊý¾Ý¿â

ÓÃADO²Ù×÷MYSQLÊý¾Ý¿â VBEÖÐÇëÈ·¶¨ÒýÓà microsoft activeX data objects xx ¿âÁ¬½Ó¼°¸üÐÂMYSQLÊý¾Ý¿âÊý¾Ý
´úÂëÈçÏÂ: Sub updt() Dim strconnt As String strconnt = "" Set connt = New ADODB.Connection Dim sevip, Db, user, pwd As String 'Éè·þÎñÆ÷µØÖ·¡¢ËùÁ¬Êý¾Ý£¬¼°µÇ¼Óû§ÃÜÂë sevip = "localhost" '"192.168.*.*" Db = "samp_db" user = "root" pwd = "6901205" strconnt = "DRIVER={MySql ODBC 3.51 Driver};SERVER=" & sevip & ";Database=" & Db & ";Uid=" & user & ";Pwd=" & pwd & ";Stmt=set names GBK" ' connt.ConnectionString = strconnt connt.Open ssql = "UPDATE student SET student.name= 'kookboy' where student.name = 'kook'" connt.Execute ssql MsgBox "³É¹¦¸üмǼ£¡" connt.Close Set connt = Nothing End Sub °´F5Ö´ÐÐ,Ö´ÐÐÇ°Öкó ½çÃæÈçÏÂ
vbaÓëmysqlÊý¾Ý¿âµÄÁ¬½Ó
Sub connect_Êý¾Ý¿â()
  Dim strconnt As String
  strconnt = ""
  Set connt = New ADODB.Connection
  Dim rs As Object
  Set rs = New ADODB.Recordset
  Dim sevip, Db, user, pwd As String
  'Éè·þÎñÆ÷µØÖ·¡¢ËùÁ¬Êý¾Ý£¬¼°µÇ¼Óû§ÃÜÂë
  sevip = "192.168.*.*"
  Db = "***"
  user = "***"
  pwd = "****"
  strconnt = "DRIVER={MySql ODBC 3.51 Driver};SERVER=" & sevip & ";Database=" & Db & ";Uid=" & user & ";Pwd=" & pwd & ";Stmt=set names GBK" '
  connt.ConnectionString = strconnt
  connt.Open
End Sub


Ïà¹ØÎĵµ£º

nagios¼à¿ØmysqlÖ÷´Ó¸´ÖÆ


nagios¼à¿ØmysqlÖ÷´Ó¸´ÖÆ
×÷ÕߣºÌïÒÝ(sery@163.com
)
ÆðÒò£ºnagios¿ÉÄܼà¿Øµ½mysql·þÎñµÄÔËÐÐÇé¿ö£¬µ«È·²»Äܼà¿ØmysqlµÄÖ÷´Ó¸´ÖÆÊÇ·ñÕý³££ºÓÐʱºò£¬Í¬²½ÒѾ­Í£Ö¹£¬µ«¹ÜÀíÈËԱȴ²»ÖªµÀ¡£
ÏÂÊÖ´¦£ºµÇ½mysql´Ó·þÎñÆ÷£¬Í¨¹ýÖ´ÐÐ mysql> show slave status\G
²é¿´ÆäÊä³ö£¬¼´¿ÉÅж¨Ö÷´Ó¸´ÖÆÊÇ·ñÕý³£¡£ÏÂÃæÊÇij¸ö´Ó·þÎ ......

MySQL Proxy°²×°ºÍʹÓÃ(Ò»)

°´ÕÕÊֲᰲװMySQL Proxy֮ǰÏÈÒª°²×°ÒÔÏÂÈí¼þ libevent 1.x or higher (1.3b or later is preferred) lua 5.1.x or higher glib2 2.6.0 or higher pkg-config libtool 1.5 or higher MySQL 5.0.x or higher developer files rpm²é¿´libevent $rpm -q libevent
libevent-1.1a-3.2. ......

mysql´æ´¢¹ý³Ì´íÎó´úÂë1307

phpmyadmin2.11.92 --APMSEVR5.2.6
д´æ´¢¹ý³ÌʱÌáʾerror 1307 (HY000):Failed to create procedure...
-----------------------------------------------------------------------
½«phpmyadminÖеÄmysqlÊý¾Ý¿âÖеıíprocɾ³ý
Ö´ÐÐÒÔÏ´úÂëÖؽ¨¸Ã±í
-------------------------------------------------------------- ......

t00lsÌṩMysql sha1²Êºç±í(»Ò³£Ç¿´ó)

½éÉÜ£º
mysql sha1
a¡£ 1 -- 11λ Êý×Ö
b¡£ 1 --  8λ  Сд×Öĸ
c¡£ 1  --  8λ  Сд×Öĸ +  Êý×Ö
d¡£ 1 --  7λ   ×Öĸ + Êý×Ö + ·ûºÅ
e¡£  1 --  8λ´óд×Öĸ 
»¹ÔÚ¼ÌÐøÉú³ÉÖÐ,ÕæÅå·þÄÌÍ·Õ⺢×ÓŪÁ˺ü¸¸öÔÂÁË¡£
ÏÂÔصØÖ·
http://down.5luyu.cn ......

MySQLѧϰ(7)varchar

      ½ñÌ콨һ¸öUTF-8µÄ±í£¬ÆäÖÐÈýÁж¼ÓÃÁËvarcharÕâ¸öÊý¾ÝÀàÐÍ£¬ÎÊÌâ¾ÍÕâôÀ´ÁË£¬ÎÒµÄÈý¸ö×ֶγ¤¶È¼ÓÆðÀ´³¬¹ýÁË65535×Ö½Ú¡£ÒÔÇ°ÒÔΪÿһ¸ö×Ö¶Î×î´óΪ65535£¬Ïë²»µ½Ò»¸ö±í¹²Ïí65535×Ö½Ú¡£Òâ˼ÊÇ˵Èý¸ö×ֶγ¤¶È¼ÓÆðÀ´²»Äܳ¬¹ý65535£¬¶ø²ÉÓÃUTF-8µÄ»°£¬Ò»¸ö×Ö·ûÊÇÕ¼Èý¸ö×ֽڵġ£¼´Èý×ֶμÓÆðÀ´µÄ×Ü ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ