Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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"
¶¼¿ÉÒÔ

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


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

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·þÎñÎÊÌâ,Çó¸ßÊÖÖ¸½Ì..

ÎÒµÄϵͳÊÇwindows XPµÄ,ÉÏ´ÎÓõçÄÔʱ¿ÉÒÔÔËÐÐmysql,µ«¹Ø»úºó,¸ô¶Ïʱ¼äÔÙ¿ª»ú,mysql¾Í²»ÄÜÕý³£ÔËÐÐÁË......¿ª»úºó,Mysql·þÎñÊÇ¿ªÆôµÄ,½ø³ÌÀïÃæµÄmysqld.exeµÄCPUÕ¼ÓÃÂÊΪ00,ÄÚ´æÊ¹ÓÃΪ72k(ºÍÎÒÉÏ´ÎÕý³£Ê¹ÓÃmysqlʱµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ