使用来自另一个表的数据更新mysql表
问题描述:
是否可以在带有子选择的mysql 5.0上运行UPDATE命令.
Is it possible to run an UPDATE command on mysql 5.0 with a sub select.
我要运行的命令是这样:
The command I would like to run is this:
UPDATE book_details
SET live = 1
WHERE ISBN13 = '(SELECT ISBN13 FROM book_details_old WHERE live = 1)';
ISBN13当前存储为字符串.
ISBN13 is currently stored as a string.
这应该更新10k +行.
This should be updating 10k+ rows.
谢谢
威廉
答
只需更改一下即可,
UPDATE book_details
SET live = 1
WHERE ISBN13 in (SELECT ISBN13 FROM book_details_old WHERE live = 1);