如何在MySQL中更新数据 [英] How to UPDATE data in MySQL

问题描述

好的，我是新来的，还在学习sql，我已经创建了一个名为users的用户，内部点默认为5.


当他们提交表单时，我用它来更新它+5分。


[PHP] $ sql = INSERT INTO''用户''SET''积分''= [+ 5] WHERE''userid''='' $ userid'';

$ result = mysql_query（$ sql，$ db）; [/ PHP]


但值永远不会从5变为10 ？

任何人都可以帮助我！

Ok, i am new here and still learning sql, i have made a table called users and inside points default 5.

and when they submit the form i use this to update it +5 points.

[PHP]$sql = INSERT INTO ''users'' SET ''points''=[+5] WHERE ''userid''= ''$userid'';
$result = mysql_query($sql ,$db);[/PHP]

But the value never changes from 5 to 10?
Can anyone please help me!

推荐答案

sql = INSERT INTO''users''SET''points''= [+ 5]在哪里''userid''=''

sql = INSERT INTO ''users'' SET ''points''=[+5] WHERE ''userid''= ''

userid'';

userid'';

result = mysql_query（

result = mysql_query(

这篇关于如何在MySQL中更新数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！