removing data from different tables together with mysql ...

[derheld]

Hi,

I have 3 tables:
1.) customer
customerID
customername
2.) data
dataID
field1
field2
3.) logic
customierID
dataID

I need a SQL statement that does the following

delete all rows in all tables to a given customername (or customerID)

(means if I want to delete a customer, I want to delete the name, all data concerning that customer that is defined in "data" and the logic that defines which data belongs to which customer)

can anyone help me building a PHP-Script or a SQL-Statement?

[TheDefender]

DELETE FROM customer, data, logic WHERE logic.customerID = customer.customerID AND logic.dataID = data.dataID AND customer.customerID = '$customerID'

(Of course, you'd want to test this out on non-productin data first 😉)

[derheld]

:-)