PDA

View Full Version : Delete from all tables where...


fuzzy1
11-06-2006, 11:43 PM
Is it possible to write a query to delete all records, from all tables, where deleted='1'?

DELETE FROM myDB.all_tables
WHERE `deleted`='1'

:confused:

harsh789
11-08-2006, 12:21 PM
I think not possible.