这是错误:
1064 - 你的SQL语法错误;检查与您的MySQL服务器版本相对应的手册,以便在第1行'case ='nominative'WHERE id = '42''附近使用正确的语法
这是查询:
UPDATE `ruen_kw` SET case='nominative' WHERE id='42'桌子:
CREATE TABLE `ruen_kw` (
`id` tinyint(6) NOT NULL auto_increment,
`language` varchar(2) NOT NULL,
`keyword` varchar(80) character set utf8 NOT NULL,
`translation` varchar(300) NOT NULL,
`case` varchar(50) NOT NULL,
`tense` varchar(50) NOT NULL,
`gender` varchar(25) NOT NULL,
`number` varchar(50) NOT NULL,
`definition` varchar(200) character set utf8 NOT NULL,
PRIMARY KEY (`id`),
FULLTEXT KEY `keyword_2` (`keyword`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=46 ;要更新的行:
INSERT INTO ruen_kw(id,language,keyword,translation,case,tense,gender,number,definition)VALUES
(42,'ru','Ñ...озÑйка','hostess','nom','','','','');