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

mysqlÖÐÔõÑùÅúÁ¿Íù±íÀï²åÈëÊý¾Ý£¿

mysqlÖÐÅúÁ¿Íù±íÀï²åÈëÊý¾Ý£¬±ÈÈçÓÐÊ®ÌõÓï¾ä£º

insert into tab1(1,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(2,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(3,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(4,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(5,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(6,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(7,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(8,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(9,'a','mmmmmmmmmmmmmmmmm');
insert into tab1(10,'a','mmmmmmmmmmmmmmmmm');

ÎÒÏëÒ»´ÎÅúÁ¿Ö´ÐУ¬²¢ÇÒµ±Ä³ÌõÓï¾ä³ö´í£¬¾Í»Ø¹ö¡£
²»Óô洢¹ý³ÌµÄ»°¸ÃÔõôд£¿£¿

insert into tab1 values(
(1,'a','mmmmmmmmmmmmmmmmm'),
(2,'a','mmmmmmmmmmmmmmmmm'),
(3,'a','mmmmmmmmmmmmmmmmm'),
(4,'a','mmmmmmmmmmmmmmmmm'),
(5,'a','mmmmmmmmmmmmmmmmm'),
(6,'a','mmmmmmmmmmmmmmmmm'),
(7,'a','mmmmmmmmmmmmmmmmm'),
(8,'a','mmmmmmmmmmmmmmmmm'),
(9,'a','mmmmmmmmmmmmmmmmm'),
(10,'a','mmmmmmmmmmmmmmmmm')
);

#f:\\MySQL\\tab1.sqlΪtab1.sqlËùÔڵķ¾¶£¬¿ÉÒÔÏÈÓüÇʱ¾±àдtab1.sql·ÅÔÚf:\\MyS


Ïà¹ØÎÊ´ð£º

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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 ¼òµ¥ÎÊÌâ

¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿

1  nike  100        ϵͳʱ¼ä
2  nike  300  &n ......

mysql´¢´æ¹ý³ÌµÄÎÊÌâ

ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£

http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......

mysqlÖÐÔõô²é¿´Ä£Ê½Ä¬ÈϵÄËÑË÷·¾¶search_path°¡

ÎÒÔÚÊéÉÏ¿´µ½ËµÃ¿Ò»¸ö±í¶¼ÊôÓÚijһ¸öģʽ£¬Èç¹ûҪΪ±íÖ¸¶¨Ä£Ê½£¬ÓÐÈýÖÖ·½·¨£º
1£©
ÔÚ´´½¨±íʱÏÔʽµÄ¸ø³öģʽÃû£¬±ÈÈçcreate table "xxx".sno(......);
2£©
ÔÚ´´½¨Ä£Ê½µÄʱºòͬʱ´´½¨±í
3) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ