Database & 技术 18 Jun 2007 02:16 pm

mysql 多表更新

可以用另一表的数据更新当前表。
UPDATE items as a,month as b SET a.price=b.price
WHERE a.id=b.id;

Trackback This Post | Subscribe to the comments through RSS Feed

Leave a Reply