Question

在sql数据库中怎么样同时更新一个表中的多个字段？？？？？？

Answer 1

UPDATE `options` SET `value` = CASE `name`
WHEN 'site_name' THEN 'My Blog'
WHEN 'site_url' THEN 'http://www.example.com'
WHEN 'site_email' THEN 'sam@example.com'
ELSE `value`
END
具体参考http://www.kavoir.com/2009/05/mysql-update-multiple-rows-with-one-single-query.html

Answer 2

多个字段用逗号分开。

Answer 3

Updae Tabe set Col1='A',Col2='B',....
where .......