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×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÏëÇë½ÌÒ»¸öÎÊÌ⣬ASP+mysql »á²»»áÓÐÁ¬½ÓĬÈÏʱ¼ä¡£
ÎÒÓöµ½Ò»¸öÎÊÌ⣺ÎÒÔÚÒ³ÃæÉϰ´Ò»¸öSave°´Å¥£¬Õâ¸ö°´Å¥ÊÇÑ»·ÔËÐÐ100ƪ insertÊý¾ÝµÄ´æ´¢¹ý³Ì¡£ asp´úÂëÓ¦¸ÃûÓдíµÄ£¬Êý¾ÝÎÒÊÇ·ÅÔÚÒ»¸öÊý×éµÄÈç¹ûÎÒÖ»±£´æ50¸öÊÇ ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
ÇëÎÊÏÂÄÄλÈÊÐÖÓбȽϺõı¸·Ý·½°¸£¬ÓÃʲô¹¤¾ß»òÕßÓÃʲô·½Ê½£¬Ð¡µÜ½è¼øÏÂ
Ö±½ÓÓÃMYSQLDUMP±¸·Ý
OR
ÓÃSQLYOGÖ®ÀàµÄͼÐλ¯¹ÜÀí¹¤¾ß±¸·Ý
Ö±½ÓÓÃmysql×Ô´øµÄ mysqldump ¾Í¿ÉÒÔÁË¡£
http://dev.mysql.com/doc/re ......