本文介绍了使用UPDATE数据库查询的SQL语法错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
晚上,我遇到语法sql错误的问题
evening all, i have an issue with a syntax sql error
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'where username = danny (name, url, banner, description, sponsor, date, password)' at line 1这是我的代码
$query = "UPDATE websites where username = $login_session (name, url, banner, description, sponsor, date, password) VALUES ('$n', '$b', '$d', '0', now(), SHA('$p'))";推荐答案
这是因为您的UPDATE语句语法错误.查看 MySQL文档以获取正确的UPDATE语法.我认为您打算用INSERT代替
That's because your UPDATE statement syntax is wrong. Check MySQL documentation for proper UPDATE syntax. I think you meant to do a INSERT rather
INSERT INTO websites (name, url, banner, description, sponsor, date, password) VALUES ('$login_session', '$n', '$b', '$d', '0', now(), SHA('$p'))
我想这就是你的追求
UPDATE websites SET name = '$n', url = '$b', banner = '$d', description = '0', sponsor = 'some_value_here', date = now(), password = SHA('$p') where username = '$login_session';更多推荐
使用UPDATE数据库查询的SQL语法错误
发布评论