使用UPDATE数据库查询的SQL语法错误 [英] Sql syntax error using UPDATE database query

问题描述

晚上，我遇到语法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语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！