星期二, 5月 17, 2005

[db][mysql]

複製同一表單欄位, (複製欄位已建立)

select field1 ,field2 from table where field1 <> field2;

update table as t1,table as t2 set t1.field1 = t2.field2 where t1.id = t2.id
張貼留言