mysql insert 1064_mysql 插入出错！#1064 请高人解达！

mysql4.12+php4.71数据库结构如下：`note_id`int(10)unsignedNOTNULLauto_increment,`note_title`varchar(40)collateutf8_unicode_ciNOTNULL,`note_time`int(20)NOTNULL,`note_info`m...

mysql 4.12+php 4.71

数据库结构如下： `note_id` int(10) unsigned NOT NULL auto_increment,

`note_title` varchar(40) collate utf8_unicode_ci NOT NULL,

`note_time` int(20) NOT NULL,

`note_info` mediumtext collate utf8_unicode_ci,

`note_image` varchar(200) collate utf8_unicode_ci default NULL,

`note_blank1` varchar(0) collate utf8_unicode_ci default NULL,

PRIMARY KEY (`note_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='网站公告' AUTO_INCREMENT=6 ;

$query = "INSERT INTO `info_cms` (`info_id`, `info_pid`, `info_title`, `info_time`, `info_info`) VALUES (NULL, '$sid', '$info_title', '$info_time', '$myinfo')";

报错为：

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `note_cms` (`note_id`, `note_title`, `note_time`, `note_info`, `i' at line 1

请大大解达~~

sql语句打错上去了~~应该是：

INSERT INTO `note_cms` (`note_id`, `note_title`, `note_time`, `note_info`, `info_image`,`note_blank1`) VALUES (NULL, '', '123123123123', '1287070543', '

dffggh

' , '', NULL)

展开