UPDATE tp_shi a set a.author =
(SELECT b.id from tp_author b where a.author = b.name);
UPDATE tp_shi a set a.author =
(SELECT b.id from tp_author b where a.author = b.name);
MySql 删除多个字段重复的数据(只…
数据替换 SELECT * from …
下面是练习表数据和结构 SET FOR…
SELECT f.* FROM law…
DELETE FROM tp_keyw…