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»ÊÇÓеãµÍÁË¡£
Ïà¹ØÎÊ´ð£º
×î½ü³öÏÖÒ»¸öºÜÆæ¹ÖµÄÎÊÌ⣬ÓÃADOÁ¬½ÓMYSQL£¬½«Á¬½ÓOPENµÄʱºò£¬Èç¹ûMYSQLÆô¶¯Ê±¾ÍÁ¬½Ó´íÎó£¬Í¬Ê±×Ô¶¯¹Ø±ÕMYSQL·þÎñ£»ÈôMYSQLûÓÐÆô¶¯¾Í¿ÉÒÔÕý³£OPEN¡£ Ò²¾ÍÊÇÿÁ½´ÎÔËÐбØÈ»»á³ö´íÒ»´Î£¬µ«Ã¿Á½´ÎÔËÐÐÒ²±ØÈ»³É¹¦Ò»´ ......
CREATE PROCEDURE dowhile() BEGIN DECLARE v1 INT DEFAULT 5; WHILE v1 > 0 DO SET v1 = v1 - 1; END WHILE; END ÎÒÔËÐÐmysql°ïÖúÀïÃæµÄ³ÌÐò»á±¨´í£¬²»ÖªµÀΪʲô£¬Çë ......
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 , ' ......
ÓÃ.net,ÔÚÁ¬½ÓmysqlÊDZ¨´í£º unable to connect to any of the specified mysql hosts. connectionString="server=ip;userid=*;password=*;database=*" ¶¥¡£¡£¡£ MYSQL ¹Ù·½ ÏÂÔØÒ»¸öÖмä¼þ. &l ......
ÎÒÓõÄÊÇmysql6.0Ϊʲôһ´´½¨Á½¸ö±íÕâ¼äÓÃÍâ¼üÀ´Á¬½Óʱ¾Í˵´´½¨²»ÁË£ºcan"nt create table ... ÄãµÄÓï¾äÊÇʲô£¿ÄãµÄ±íÊÇʲô´æ´¢ÒýÇæ£¿ Èç¹ûÊÇmyisam Ôò²»Ö§³ÖÍâ¼ü£¬ÄãÐèÒª°Ñ±í¸ÄΪinndb 貼³öSQL ......