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

mysql ´´½¨¹ØÁª

SQL code:
alter table `test`.`shangpin` add constraint `FK_shangpin_dingdan` FOREIGN KEY (`shangPinID`) REFERENCES `dingdanshangpinxiang` (`shangPinID`) ON UPDATE RESTRICT

±¨´í£º
Can't create table '.\test\#sql-588_2fa.frm' (errno: 150)

±íʲôÒýÇæ¡¢ÊÇ·ñ´æÔÚ¡¢ÊÇ·ñÓмǼ


Ïà¹ØÎÊ´ð£º

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 update ÑÏÖØÎÊÌâ


ÏÖÔÚÎÒÏëʵÏÖÒÔÏ·½·¨£º

»·¾³struts2+ibatis2.3+mysql5

    ´ÓjspµÃµ½Êý¾ÝºóÏÈupdate £¬Èç¹ûÊý¾Ý¿âÀïûÓиÃÐÅÏ¢ÔÙ insert £¬ÎÒÓÃÁËtry catch Òì³£²¶×½£¬±¾Ïëtry{ update}

catc ......

MySQL¶àÏß³Ì

ÔÚ½øÐÐÊý¾Ý¿â¶ÁдµÄʱºò£¬Ò»°ãÇé¿ö϶¼Êǵ¥Ï̵߳쬵«ÊÇÈçºÎÔÚ²Ù×÷µÄʱºòҲʹÓöàÏß³ÌÄØ£¿Ê¹ÓöàḬ̈߳²È«Â𣿶àÏß³ÌÊÇÈçºÎ±£Ö¤°²È«µÄÄØ£¿Èç¹ûÓдúÂëµÄ»°£¬Ìù³öÀÛ»òÕß°Ñ´úÂë¹²Ïí¸øÎÒѧϰѧϰ¡£¡£¡£¶àл£¡
ÄãÊÇÖ¸ÍâÃæ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ