ÓÃ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
Ïà¹ØÎĵµ£º
ÔÚMySQLÖУ¬¼ÓÃܺÍѹËõº¯Êý·µ»Ø¶þ½øÖÆ´®¡£¶ÔÆäÖеÄÐí¶àº¯Êý¶øÑÔ£¬½á¹û¿ÉÄÜ°üº¬ÈÎÒâµÄ×Ö½ÚÖµ£¬Èç¹ûÏë´æ´¢ÕâЩ½á¹û£¬ÄãÓ¦¸ÃʹÓÃÒ»
¸ö¾ßÓÐvarbinary»òÕßblob¶þ½øÖÆ´®Êý¾ÝÀàÐ͵ÄÁУ¬Õâ¿É±ÜÃâDZÔÚµÄɾ³ýβ²¿¿Õ°×ÎÊÌâ»òÕß×Ö·û¼¯×ª»»ÎÊÌâ¡£ÕâЩÎÊÌâ¿ÉÄܵ¼ÖÂÊý¾ÝÖµµÄ¸Ä±ä¡£Ò»°ã¶øÑÔ£¬ÉÏÊöÎÊÌâ¿ÉÄÜÔÚÄãʹÓ÷Ƕþ½øÖÆ´®Êý¾ÝÀàÐÍ£¨Èçch ......
ÔÚѧϰ£¼Linux³ÌÐòÉè¼Æ£¾µÚ8ÕÂMySQLÊý¾Ý¿â8.3½Ú£º
ʹÓÃCÓïÑÔ·ÃÎÊMySQL·ÃÎÊÊý¾Ý¿âʱ³¢ÊÔ°ÑSQLÊý¾Ý»»³ÉÁËÖÐÎÄ£¬µ«ÊÇÔÚÔËÐÐʾÀý³ÌÐòʱÖÕ¶ËÊä³öÈ´ÂÒÂ룬MySQL C ÓïÑÔÁ¬½ÓĬÈÏ×Ö·û¼¯ÊÇlatin1
²éÁËÏÂAPIÕÒµ½ÈçϺ¯Êý¿É½â¾öÖÐÎÄÂÒÂëÎÊÌâ¡£
int
mysql_set_character_set(
MYSQL *
mysql,
char
*
csname)
ÃèÊö
¸Ãº¯ÊýÓ ......
½éÉÜ£º
mysql sha1
a¡£ 1 -- 11λ Êý×Ö
b¡£ 1 -- 8λ Сд×Öĸ
c¡£ 1 -- 8λ Сд×Öĸ + Êý×Ö
d¡£ 1 -- 7λ ×Öĸ + Êý×Ö + ·ûºÅ
e¡£ 1 -- 8λ´óд×Öĸ
»¹ÔÚ¼ÌÐøÉú³ÉÖÐ,ÕæÅå·þÄÌÍ·Õ⺢×ÓŪÁ˺ü¸¸öÔÂÁË¡£
ÏÂÔصØÖ·
http://down.5luyu.cn ......
½ñÌ콨һ¸öUTF-8µÄ±í£¬ÆäÖÐÈýÁж¼ÓÃÁËvarcharÕâ¸öÊý¾ÝÀàÐÍ£¬ÎÊÌâ¾ÍÕâôÀ´ÁË£¬ÎÒµÄÈý¸ö×ֶγ¤¶È¼ÓÆðÀ´³¬¹ýÁË65535×Ö½Ú¡£ÒÔÇ°ÒÔΪÿһ¸ö×Ö¶Î×î´óΪ65535£¬Ïë²»µ½Ò»¸ö±í¹²Ïí65535×Ö½Ú¡£Òâ˼ÊÇ˵Èý¸ö×ֶγ¤¶È¼ÓÆðÀ´²»Äܳ¬¹ý65535£¬¶ø²ÉÓÃUTF-8µÄ»°£¬Ò»¸ö×Ö·ûÊÇÕ¼Èý¸ö×ֽڵġ£¼´Èý×ֶμÓÆðÀ´µÄ×Ü ......
Ò» . °²×°ÓëÅäÖÃMYSQL
¡¡¡¡¶þ . ³£ÓÃmysqlÃüÁîÐÐÃüÁî
¡¡¡¡1 .mysqlµÄÆô¶¯ÓëÍ£Ö¹
¡¡¡¡Æô¶¯MYSQL·þÎñ net start mysql
¡¡¡¡Í£Ö¹MYSQL·þÎñ net stop mysql
¡¡¡¡2 . netstat –na | findstr 3306 ²é¿´±»¼àÌýµÄ¶Ë¿Ú , findstrÓÃÓÚ²éÕÒºóÃæµÄ¶Ë¿ÚÊÇ·ñ´æÔÚ
¡¡¡¡3 . ÔÚÃüÁîÐÐÖеǽMYSQL¿ØÖÆ̨ , ¼´Ê¹Óà MYSQL COM ......