Question

MYSQL : insert into 的问题

insert into 'musiclist' ('musicId','musicName','singerName','CDTitle','size','duration','format','area','musicTag','imageUrl','Url','date','clicks','other','style' )
values('20','光辉岁月','黄家驹','1111','5','00:00:00','1','中国台湾','1','1','E:/AppServ/www/lyko2/music/老男孩.mp3','2010-11-29','1','1','流行');

为什么报错啊：[Err] 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 ''musiclist' ('musicId','musicName','singerName','CDTitle','size','duration','for' at line 1

Answer 1

表名 列名这里不用加引号insert into 'musiclist'
insert into musiclist(musicid, musicname, singername)
values('20', '1111', 'zhang san')

insert into musiclist
(musicId','musicName','singerName','CDTitle','size','duration','format','area','musicTag','imageUrl','Url','date','clicks','other','style' )
values('20','光辉岁月','黄家驹','1111','5','00:00:00','1','中国台湾','1','1','E:/AppServ/www/lyko2/music/老男孩.mp3','2010-11-29','1','1','流行');

Answer 2

我也是遇见过同样错误，就是在insert into 'musiclist' ('musicId','musicName','singerName','CDTitle','size','duration','format','area','musicTag','imageUrl','Url','date','clicks','other','style' )的单引号得需要用键盘中左上角的~键输入，后面的才能用“键中的单引号输入