INSERT INTO `wog_mission_main` VALUES (1,'近日村内的渔网因为已经长年使用而不堪修补了,必须全面换新,希望有人能够帮忙搜集制作渔网的材料。 \r\n\r\n完成条件:蜘蛛丝*3 \r\n任务奖励:白色布料*1','感谢您的努力,让渔村可以继续用渔网捕鱼\r\n但是最近常常有鱼群大量死亡,我怀疑是上游的恶水族搞的鬼\r\n\r\n可在银鲸任事所接受这项任务','制作渔网','渔人码头村长 周渔民',1,3,99,0,0,0,NULL,1,0,'0',0,0);
输入这条命令以后 出现 '> 说缺少个分号?? 我最后打上去个'然后打; 出现 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 '' at line 1
麻烦各位高手指点一二
CREATE TABLE `wog_mission_main` ( `m_id` int(10) unsigned NOT NULL auto_increment, `m_body` text NOT NULL, `m_end_message` text NOT NULL, `m_subject` varchar(100) NOT NULL default '', `m_name` varchar(50) NOT NULL default '', `m_lv` int(10) unsigned NOT NULL default '0', `m_sex` tinyint(1) unsigned NOT NULL default '0', `m_job` tinyint(4) unsigned NOT NULL default '0', `m_rating` int(10) unsigned NOT NULL default '0', `m_need_id` int(10) unsigned NOT NULL default '0', `m_not_id` int(10) unsigned NOT NULL default '0', `m_birth` tinyint(4) unsigned default NULL, `m_store_id` tinyint(1) unsigned NOT NULL default '0', `m_area_id` tinyint(3) unsigned NOT NULL default '0', `m_monster_id` varchar(15) NOT NULL default '0', `m_kill_num` tinyint(3) unsigned NOT NULL default '0', `m_pet_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`m_id`), KEY `m_lv` (`m_lv`), KEY `m_sex` (`m_sex`), KEY `m_job` (`m_job`), KEY `m_rating` (`m_rating`) ) TYPE=MyISAM;
ERROR 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 '' at line 1