benen005 发表于 2013-1-28 14:41:03

[Mysql] How to change value in MySQL

we are here for the moment ...

RUN MySQL under DOS:

show databases;

table test
--------------------------------------
id value

1 3
2 2
--------------------------------------

we wants to change the value of a and b

let's do it.

'update test set value = 2 where id = 1'
'update test set value = 3 where id = 2'

right. it's done.
页: [1]
查看完整版本: [Mysql] How to change value in MySQL