inner join
update users as u1
inner join users as u2
on u1.id = u2.id
set u1.mail = concat('test+', u2.id, '@example.com');履歴
- 第 1 版西小倉パンデイロ2011-05-16 09:49:58
update users as u1
inner join users as u2
on u1.id = u2.id
set u1.mail = concat('test+', u2.id, '@example.com');