Jump to content

Delete data with multiple database


yanti

Recommended Posts

Hi,

 

I had this problem which deleting data within 2 different database. My code is below:

 

SELECT b.* FROM 33080_cdr.mt_1201 a INNER JOIN mot.mot9_member_on b ON a.mobile_no=b.mobile WHERE a.dn_status='psanumberbarred'

 

this will select all the data that i want to delete. please help me how to delete the selected result.

 

thank you  :(

Link to comment
https://forums.phpfreaks.com/topic/259722-delete-data-with-multiple-database/
Share on other sites

Provided you have no referential integrity you can do something similar to the following.

 

DELETE b FROM mot.mot9_member_on b INNER JOIN 33080_cdr.mt_1201 a ON a.mobile_no=b.mobile WHERE a.dn_status='psanumberbarred'

 

Consider renaming your databases, tables and fields with more descriptive titles as well. Currently, it is very elusive and unmemorable.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.