我正在尝试一次更新多个列:
$query="UPDATE search_page
SET search_page_description='".$search_page_description."',
SET title='".$title."',
SET h1='".$h1."',
SET meta_description='".$metadata."'
WHERE features_id=".$id;
$result_update_query=databaseConn :: dbDelta($query);
我明白这个:
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 title='fasdf', SET h1='fasdfas', SET meta_description='fas' at line 3
我的代码哪里出错了?
你只需要一个SET
关键字
$query="UPDATE search_page
SET search_page_description='".$search_page_description."',
title='".$title."',
h1='".$h1."',
meta_description='".$metadata."'
WHERE features_id=".$id;
$result_update_query=databaseConn :: dbDelta($query);
参见参考: http://dev.mysql.com/doc/refman/5.5/en/update.html
试试这些:
> $query="UPDATE search_page
> SET search_page_description='".$search_page_description."',
> title='".$title."',
> h1='".$h1."',
> meta_description='".$metadata."'
> WHERE features_id=".$id;
> $result_update_query=databaseConn :: dbDelta($query);
错误显示第 3 行,如下所示:
"设置标题=".$title."',"
问题是此行包含预期的"SET"关键字。
$query="UPDATE search_page
SET search_page_description='".$search_page_description."',
title='".$title."',
h1='".$h1."',
meta_description='".$metadata."'
WHERE features_id=".$id;
$result_update_query=databaseConn :: dbDelta($query);
请参阅 MySQL 参考或尝试 SQL 更新语句