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

mysql½¨±í´íÎó - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÓÃmysql½¨±íʱ³öÏÖ´íÎó1067 £ºinvalid default value for 'id'
idÊÇintÐ͵ģ¬ÎªÊ²Ã´²»ÄÜÉèÖÃĬÈÏÖµ¡£Óï¾äΪid int£¨4£©default '-1' null;³öÏÖ´íÎó¡£
Ìù³öÄãµÄ create table Óï¾ä£¬¼°ÄãµÄmysql °æ±¾¡£

µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html


ÓÐauto_increment ²»ÄÜdefault

»¹ÊÇÌù³öÄã×Ô¼ºµÄ½¨±íÓï¾ä±È½ÏºÃ

idÄãÊDz»ÊǸøÉèÖõÄÊÇÖ÷¼ü°¡£¬Ö÷¼üÄãÔõô¿ÉÒÔ¸øÒ»¸öĬÈÏÖµ°¡£¿

ÒýÓÃ
ÓÃmysql½¨±íʱ³öÏÖ´íÎó1067 £ºinvalid default value for 'id'
idÊÇintÐ͵ģ¬ÎªÊ²Ã´²»ÄÜÉèÖÃĬÈÏÖµ¡£Óï¾äΪid int£¨4£©default '-1' null;³öÏÖ´íÎó¡£

°Ñ'-1'¸ÄΪ-1ÊÔÊÔ£¬¼ÈÈ»ÓÐdefaultÖµ£¬¿ÉÒÔÖ¸¶¨Îªnot nullµÄ¡£
ÄãµÄÕâ¸öÓï¾äÆäʵÔÚ5.0ÀïÍ·ÊÇ¿ÉÒÔÖ´Ðе쬻³ÒÉÄãµÄmysql°æ±¾ÊDz»ÊÇÓеãµÍÁË¡£



Ïà¹ØÎÊ´ð£º

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

netbeans Á¬mysql - Web ¿ª·¢ / HTML(CSS)

ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......

sqlÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÔõôÑù²éѯÁ¬½Ó2¸ö±íÖ®ºó µÃ³öµÄбí
ÀýÈç A±í£º·¢¼þÈËID Óʼþ±àºÅ ÓʼþÄÚÈÝ ÊÕ¼þÈËID ·¢¼þʱ¼ä
  B±í£ºÊÕ¼þÈËID Óʼþ±àºÅ ÊÕ¼þʱ¼ä
  Ê×ÏÈ×öA BµÄÁ¬½Ó²éѯ ¼´ Óʼþ±àºÅÏàµÈ
  ²é³ö£ ......

mysqlÍâ¼ü - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÎÒÓõÄÊÇmysql6.0Ϊʲôһ´´½¨Á½¸ö±íÕâ¼äÓÃÍâ¼üÀ´Á¬½Óʱ¾Í˵´´½¨²»ÁË£ºcan"nt create table ...
ÄãµÄÓï¾äÊÇʲô£¿ÄãµÄ±íÊÇʲô´æ´¢ÒýÇæ£¿ Èç¹ûÊÇmyisam Ôò²»Ö§³ÖÍâ¼ü£¬ÄãÐèÒª°Ñ±í¸ÄΪinndb

貼³öSQL&# ......

ADOÖ´ÐÐMYSQL´æ´¢¹ý³ÌµÄÎÊÌâ - VC/MFC / Êý¾Ý¿â

begin
insert into userInfo(userName,userCode,delOrNot) values(in_userName,in_userCode,0);
end
´æ´¢¹ý³Ì£¬Á¬MYSQL NAVICATÀïÃæÐ´µÄ£¬²âÊÔ£¬²ÎÊý²»ÊÇÖÐÎľÍOK£¬¿ÉÒÔÔËÐÐ
±ÈÈçÎÒ²ÎÊý: 'wangwu','cctv-2010'ÔË ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ