Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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»ÊÇÓеãµÍÁË¡£



Ïà¹ØÎÊ´ð£º

eclipseÁ¬½ÓmysqlÊý¾Ý¿â - Java / Eclipse

ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......

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

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

PHP+MYSQLÊý¾Ý¼¯´¦Àí - PHP / »ù´¡±à³Ì

1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......

mysqlÔ¤´¦Àí - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

SQL code:

create procedure proc_batchUpdate(in categoryId integer , in artIds varchar(50))
begin
set @dsql = count('update article set type=' , categoryId , ' where id in (' , artIds , ' ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ