msyql中set不能插数据吗？
SQL 查询：
insert into 'comment' set 'poster'='test','mail'='test@123.com','comment'='test','reply'='','date'='2016-03-25 13:10:01','ip'='192.168.243.1'
MySQL 返回： 
#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 ''comment' set
'poster'='test','mail'='test@123.com','comment'='test','reply'='',' at
line 1
慕娘6614456浏览 1915回答 3
3回答
-
Life_Unexpected
把数据tbl_name和col_name上的引号去掉，赋的值是否需要引号，要看它是什么类型的！ -
灬紫羽
insert into table values(); update table set ... -
mfkayuff
嗯，是的，SET是配合UPDATE用的
随时随地看视频慕课网APP
PHP
SQL Server