Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

MySQLÊý¾Ý°ü¹ý´ó

ÎÒÓÃÒ»¸öÑ­»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ


public static final DataBase.MAXSIZE=102 ......

¹ØÓÚmysql´æ´¢¹ý³Ì±äÁ¿µÄÎÊÌ⣿

¹ØÓÚmysql´æ´¢¹ý³Ì±äÁ¿µÄÎÊÌ⣿±äÁ¿Ê²Ã´Ê±ºòÇ°ÃæÒª¼Ó@·ûºÅ£¬ÓÃdeclareÉùÃ÷µÄ±äÁ¿ÓëǰÕßÓкÍÇø±ð£¬ÎÒ²»¶®£¿
@ÊÇÓÃÀ´ÆÁ±Î´íÎó»ò¾¯¸æµÄ£¬µ±Ç°Ãæ¼ÓÁË@·ûºÅºó£¬Èô´Ë´¦Óдí»ò¾¯¸æ£¬ÍøÒ³½«²»ÏÔʾ³öÀ´¡£

Ç°Ãæ¼Ó@´ú±í»á»° ......

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

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

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

oracle ¶ÔÓ¦µÄMySQLµÄÓï¾ä

orcle Óï¾ä create table book1(name, price) as select book_name, price form book;
¶ÔÓ¦µÄMySQLµÄÓï¾äÊÇʲô

create table book1 as select book_name, price form book; ÕâÑùÔÚMySQLÀï¿ÉÒÔ£¬µ«ÊÇÈ´² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ