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

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


Ïà¹ØÎÊ´ð£º

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

mysql:´´½¨Ë÷Òý³ö´í

´ó¼ÒºÃ£¬ÎÒÔÚ´´½¨Ë÷Òýʱ£¬³öÏÖ´íÎóÌáʾ£¬´úÂëÈçÏ£º

create uique index stu_cou_index on student_info.results (student_id, course_id);
show index from student_info.results;

±£´æÎªindex ......

CÓïÑÔ Mysql ÒÉÎÊ

if(mysql_init(&mysql)==NULL)
{
sprintf(ErrMsg,"We are outof Memory");
return(false);
}

if(!mysql_real_connect(&mysql,"localhost","test" ......

MySQLÊý¾Ý°ü¹ý´ó

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


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

MYSQLÖиù¾Ý×Ö¶ÎÖµÅжϷµ»Ø²»Í¬µÄÖµ

ÔÚmysqlÖÐÓÐÒ»ÕÅ±í£¬ÓÐÈý¸ö×Ö¶Îtotal,max, min£¬¶¼ÊÇintÐ͵ÄÖµ£¬¿ÉÒÔдһ¸ösqlÓï¾äÍê³É¹¦ÄÜ£º
¸ù¾ÝÿÌõ¼Ç¼ÖУ¬Èç¹ûtotal>max,·µ»Ø2£¬Èç¹ûtotal <min·µ»Ø1£¬Èç¹û¶¼Ìõ¼þ¶¼²»·ûºÏ·µ»Ø0¡£¼±Ç󣡣¡£¡£¡
mysql? ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ