Thursday, October 21, 2010

MYSQL - To Delete records from tableA that matching records from tableB

DELETE FROM t1 USING nplay_offline.sms_out_message AS t1 INNER JOIN nplay_delete.sms_out_message AS t2 WHERE t1.id=t2.id;

No comments:

Post a Comment