php+mysql修改记录出错？
我在MYSQL数据库里执行以下语句updatesetlastvisit='1162781909'fromcdb_memberswhereuid='6'就会出现。。。错误S...
我在MYSQL数据库里执行以下语句
update set lastvisit='1162781909' from cdb_members where uid='6'
就会出现。。。
错误
SQL 查询 :
UPDATE SET lastvisit = '1162781909' FROM cdb_members WHERE uid = '6'
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 'SET lastvisit = '1162781909' FROM cdb_members WHERE uid = '6'
请问这是什么原因啊？怎么解？谢谢了~！ 展开
update set lastvisit='1162781909' from cdb_members where uid='6'
就会出现。。。
错误
SQL 查询 :
UPDATE SET lastvisit = '1162781909' FROM cdb_members WHERE uid = '6'
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 'SET lastvisit = '1162781909' FROM cdb_members WHERE uid = '6'
请问这是什么原因啊？怎么解？谢谢了~！ 展开
1个回答
展开全部
SQL语句错了
update cdb_members set lastvisit='1162781909' where uid='6'
update cdb_members set lastvisit='1162781909' where uid='6'
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
