以前有两张表
users表:
uid uname upwd user_more表:
id uid uemail现在有万条记录了,更改了表结构,把uemail字段移到users表了
要把记录也已过去,有办法没?
users表:
uid uname upwd user_more表:
id uid uemail现在有万条记录了,更改了表结构,把uemail字段移到users表了
要把记录也已过去,有办法没?
调试欢乐多
SET col_name1=expr1 [, col_name2=expr2 ...]
[WHERE where_definition]//example:
UPDATE items,month SET items.price=month.price
WHERE items.id=month.id;