mssqlÓëmysql»¥·ÃÎÊÌâ
ÏÖÔÚ×÷Á˸öϵͳ,Êý¾Ý¿âʹÓÃmysql,µ«ÊÇÐèÒª´ÓÁíÒ»¸öMSSQLÖлñµÃһЩ»ù´¡Êý¾Ý,Çë½Ì¸÷λ,ÎÒÄܲ»ÄÜͨ¹ýÒ»ÖÖ·½Ê½»ñµÃÏ໥µÄÊý¾Ý,лл!
MS SQL server µ¹ÊÇ¿ÉÒÔÔÚÕâ¼ÜWINODWS ·þÎñÆ÷Éϰ²×°MYSQLµÄODBCÇý¶¯£¬È»ºó½øÐзÃÎÊ¡£
mysql ·ÃÎÊSQL SERVERûÓа취¡£
ÓóÌÐò´¦Àí£¬±ÈÈçMySQLµÄÊý¾ÝÇ¨ÒÆ¹¤¾ß¾ÍÊÇÀûÓÃJDBCµÄ£¬¿ÉÒÔ½«Oracle/SQL SvrµÄÊý¾Ýµ¼ÈëMySQL
Ö»ÄÜÔÚMSSQLµÄÄÇ̨»úÆ÷ÉϲÙ×÷ÁË£¬´ÓMYSQLÀï¶ÁÊý¾Ý£¬»òÕß°ÑÊý¾Ýдµ½MYSQLÀMYSQL ·ÃÎÊMSSQLû°ì·¨¡£
ÇëÍÆ¼öÒ»¿îODBCÁ¬½ÓÆ÷,ÎÒÏÖÔÚÓõÄÊÇmysql odbc 3.51 dirver ÄÜÔÚ¿ØÖÆÃæ°åÀィÁ¢Êý¾Ý¿âÁ¬½Ó.
Ò²ÄÜͨ¹ýpowerbuild·ÃÎÊÊý¾Ý¿â,µ«ÊÇÔÚMSSQLÀïÃæÌí¼Ó·þÎñÆ÷Á¬½Óʱ»¹ÊÇûÓÐMYSQLµÄODBCÇý¶¯Ñ¡Ïî
ÏÖÔÚ×÷Á˸öϵͳ,Êý¾Ý¿âʹÓÃmysql,µ«ÊÇÐèÒª´ÓÁíÒ»¸öMSSQLÖлñµÃһЩ»ù´¡Êý¾Ý
û¸ãÇå³þÉ¶ÍæÒâ½ÐÒ»¸öϵͳ£¬Èç¹ûÊÇÓõÄijÓÃÓïÑÔ×öµÄijÈí¼þÖ®ÀàµÄ¶«Î÷¡£¶ÁÁ½¸ö¿âÍêÈ«ÊÇûÓÐÎÊÌâµÄ¡£
Èç¹ûÊÇ×öÁËij¸öÎÒδ֪µÄϵͳ£¬ÄǾͲ»ºÃÒâ˼µÄ£¬ÎÒ¼ûʶ¶Ì....
Êý¾Ý¿â±¾Éíȥȥ±ðµÄ¿âÀï¶Á¶«Î÷Âð£¿ÄÇ»ù±¾ÉϾÍÊÇÊý¾ÝµÄͬ²½Ê²Ã´µÄ....
ºÜÎÞÓïÕâÑùµÄ±í´ïÄÜÁ¦¡£
ºÃµÄ,лл,ÎÒÔÙÊÔÒ»ÏÂ
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ÉÊÇÎÒÕÒ ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í:
You can't specify target table 'a_table' for update in from clause
ÍêÕûSQLÓï¾äÊÇ
UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......
echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£
echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
......