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

winxp ÏÂʹÓÃmysqlµ½µ×ºÏ²»ºÏÊÊ£¿

ÎÒ¾õµÃsqlserverÌ«ÅÓ´óÁË£¬Âé·³£¬ÓÚÊÇÏëÓÃmysql£¬¿ÉÊÇ×°ÁËmysql5.0ÒÔºó²Ù×÷Êý¾Ý¿â×ÜÊdzöÏÖ¡°multiple-step operation gernerated error check each status value¡±µÄÎÊÌâ¡£µ½ÍøÂçÉÏËÑÁËһϣ¬ÓÐÈË˵ÕâÊÇmysql5.0µÄÎÊÌ⣬×îºÃ¸ÄÓõͰ汾£¬È»ºóÎҸijÉÁË4.1£¬½á¹û5.0µÄÊý¾Ý½á¹¹ÎÞ·¨µ¼Èëµ½4.1£¬²¢ÇÒ4.1ÔÚʹÓÃÃüÁîÐÐʱÁ¬½Ó²»ÉÏ¡°can't connect to mysql server on 'localhost' <10061> ¡±¸ãÁ˰ëÌìÒ²²»ÖªµÀΪʲô¡£Óе㷳ÔêÁË£¬Ïë¸ÄÓÃsqlserver¡£
ÊDz»ÊÇwidowsÏ»¹ÊDz»ÒªÊ¹ÓÃmysqlΪºÃÄØ£¿
SQLÓï¾äÊÇʲô£¬Óû§¡¢ÃÜÂëÊÇ·ñÕýÈ·

¿´Ò»ÏÂÄãµÄMYSQLµÄ´íÎóÈÕÖ¾ÖеÄÐÅÏ¢ÓÐЩʲôÌáʾ¡£

Ò»°ãÓ¦¸ÃÑ¡Ôñ°²×°Õýʽ·¢²¼µÄ×îаæ
Ŀǰ£¬Ó¦¸ÃÊÇ 5.1.41

ÎÒÊ×ÏÈÏëÖªµÀmysql5.0µ½µ×ÊDz»ÊÇÓÐÄǸöÎÊÌâ

ÄÇÎÒÊÔÊÔ£¡Èç¹ûºÃÓ㬸øÄã¼Ó·Ö

¸Õ²Å¿´ÁËһϣ¬×îеÄÒѾ­5.5ÁË£¬²»ÖªµÀÕâ¸öÔõôÑù

×îеÄÕýʽ·¢²¼ÊÇ 5.1.41

5.4 ÊÇbeta ·¢²¼°æ

Ó¦¸ÃûÓÐÎÊÌâµÄ£¬¿ÉÄÜÊÇʹÓ÷½·¨µÄÎÊÌâ
ÎÒÃÇÒ»Ö±ÓÃҲûÓÐÓöµ½ÎÊÌ⣬ÎÒÔÚÍøÉÏËÑË÷ÁËһϣ¬ÓÐÈË˵ÊÇ×Ö¶ÎÀàÐͲ»ÕýÈ·£¬±ÈÈçÒª°ÑÒ»¸ö100×Ö½ÚµÄ×Ö·û´®Ð´µ½Ò»¸övarchar(50)ÀïÃæÈ¥
½¨ÒéÄã¼ì²éÒ»ÏÂ×Ö¶ÎÀàÐÍÉèÖÃÊÇ·ñÓÐÎÊÌ⣬ÊÇ·ñ¸úÊý¾ÝÓ㤶ÈÉϵijåÍ»

ûÓÐÎÊÌâµÄ¡£ÎÒÒ»Ö±ÔÚxpÏÂÓÃ

Â¥Ö÷ÊìϤÄǸöÊý¾Ý¿â¾ÍÓÃÄĸö£¬Ã»ÓбØÒªÇ¿Çó¡£ÕâÁ½¸öÊý¾Ý¿âÎÒ¶¼ÔÚwindowsÏÂÓ㬶¼ºÜºÃÓá£Ö»²»¹ýSQL serverÒªÊÕ·Ñ£¬µ«ÊÇËûʲô¶¼°ïÄãÉèÖúÃÁË£¬¼òµ¥Ò»Ð©¡£  MySql5ÌØ±ðÊÇ5.1ÒÔÉϰ汾£¬Ò²ÍêÈ«Âú×ãÆóÒµ½Ï´óÐÍÊý¾Ý¿âµÄÐèÇó£¬Ö»²»¹ý¿ªÔ´µÄÁé»îµÄ¶«Î÷£¬ÐèҪͶÈë¸ü¶à¾«Á¦À´¶¨ÖÆÅäÖÃËüÒÔÂú×ãÄãµÄÒªÇó¡£
¶ÔÓÚ¿ª·¢À´Ëµ£¬·Ç³£½¨ÒéÂ¥Ö÷°²×°MySql 5.1 ÒÔÉϰ汾µÄ essential °æ±¾£¬Í¨¹


Ïà¹ØÎÊ´ð£º

mysqlµÄÁ¬½Ó³¬Ê±Ê±¼äÔõôÉèÖà - VC/MFC / Êý¾Ý¿â

ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......

ASP +Mysql proc

ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£
ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ­»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇ ......

Sqlserver Óï¾äת³ÉMySqlÓï¾ä

Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......

¹ØÓÚMYSQLµÄinnodb±í±¸·ÝµÄÎÊÌâ

ÇëÎÊÏÂÄÄλÈÊÐÖÓбȽϺõı¸·Ý·½°¸£¬ÓÃʲô¹¤¾ß»òÕßÓÃʲô·½Ê½£¬Ð¡µÜ½è¼øÏÂ
Ö±½ÓÓÃMYSQLDUMP±¸·Ý
OR
ÓÃSQLYOGÖ®ÀàµÄͼÐλ¯¹ÜÀí¹¤¾ß±¸·Ý

Ö±½ÓÓÃmysql×Ô´øµÄ mysqldump ¾Í¿ÉÒÔÁË¡£
http://dev.mysql.com/doc/re ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ