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

mysqlµ¼ÈëÊý¾Ý¿âÎÊÌâ

ÔÚdocÏÂÖ´Ðе¼ÈëÃüÁî
  mysql -uadmin -padmin student < d:\a.txt
ʱÌáʾϵͳÕÒ²»µ½Îļþ£¬»·¾³±äÁ¿¶¼ÉèÖöÔÁ˰¡£¬Ö®Ç°Ò²Ã»ÓгöÏÖ¹ýÕâ¸ö´íÎó£¬Çë´ó¼Ò°ïæ½â¾öÏ£¡Ð»ÁË£¡£¡
mysql -uadmin -padmin student < d:\\a.txt

ÊÇÔÚϵͳDOSÏÂÖ´ÐеϹÊÇÔÚMYSQLÃüÁîÐÐÏÂÖ´ÐУ¿

Ó﷨û´í
È·¶¨ÎļþÔÚÂð£¿
ÔÚdosÏÂcmd¿´¿´Îļþ£º
SQL code:
type d:\a.txt


ÒýÓÃ
mysql -uadmin -padmin student < d:\\a.txt

Íü¼ÇÁË£¬¿ÉÄÜÎÒÒÔǰÓõÄÊÇ·´Ð±¸Ü£¬Ó÷´Ð±¸ÜµÄ»°¾ÍÖ»ÓÃÒ»¸ö¶Ô°É¸÷λ£¿£¿£¿

ÔÚϵͳDOSÏÂÓÃÒ»¸ö·´Ð±¸Ü¾Í¿ÉÒÔÁË£¬ÄãµÄϵͳÊÇWINDOWS£¿

ÒýÓÃ
ÊÇÔÚϵͳDOSÏÂÖ´ÐеϹÊÇÔÚMYSQLÃüÁîÐÐÏÂÖ´ÐУ¿

ÔÚϵͳDOSÏÂÖ´ÐÐ
ÎļþҲȷʵ´æÔÚ

ÒýÓÃ
ÔÚϵͳDOSÏÂÓÃÒ»¸ö·´Ð±¸Ü¾Í¿ÉÒÔÁË£¬ÄãµÄϵͳÊÇWINDOWS£¿

windows xp

C:\Documents and Settings\Administrator>mysql -u root -p <"D://test/z1.txt"
C:\Documents and Settings\Administrator>mysql -u root -p <"D:\test\z1.txt"
C:\Documents and Settings\Administrator>mysql -u root -p <"D:\test/z1.txt"
C:\Documents and Settings\Administrator>mysql -u root -p <"D://test\z1.txt"
¶¼¿ÉÒÔ

Ó¦¸Ã¿ÉÒÔ£¬ÓÐÎÞÈ«½Ç¡¢°ë½ÇÎÊÌ


Ïà¹ØÎÊ´ð£º

mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ

mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ

±ÈÈçÕë¶ÔdbÖ®¼äµÄ»¥Ïà·¢ÏûÏ¢¡¡£¨ÏûÏ¢´«µÝ£©

ûÓС£

³ý·ÇÄã×Ô¼º¸ÄдһÏÂMYSQLµÄÔ´´úÂëÈ»ºó±àÒëÔËÐС£

½èÖúÆäËûÓïÑÔ

ĿǰµÄmysqlÀïÃæÏÖ³ÉÕâÑùµÄ¹¦ÄÜ¡£ ......

MySQL´´½¨´æ´¢¹ý³Ì³ö´í

ÔÚMySQL5.0Öд¬½¢´æ´¢¹ý³Ìͨ²»¹ý£¬Ìáʾ£º
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' ......

Mysql Êý¾Ý¿âɾ³ý²»ÁËÔõô°ì

ÎÒ֮ǰµ¼ÈëµÄÊý¾Ý¿â£¬ÏÖÔÚɾ³ý²»ÁË£¬ÓÃÁËÃüÁîÐк͹¤¾ß¶¼²»ÐУ¬ÖØÆôÒ²²»ÐУ¬ÕâÊÇÎªÊ²Ã´ÄØ£¿
ÄãÊÇÈçºÎɾ³ýµÄ£¿
ÓÐʲôÌáʾ£¿


ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©

......

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

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

AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ