Deleting a record from multiple tables

[ashalatha]

how can i delete a record from multiple tables

Iam having category id in category table,and in orders table.If iam deleting in that id in category table at a time it should delete in orders table also how can i do this can anyone help me.

Thanks in advance

[cereal]

You could use foreign keys constraints:

• http://dev.mysql.com/doc/refman/5.5/en/create-table-foreign-keys.html

If you have doubts, show us the tables schema.

See cereal's link and pay attention to CASCADE. This won't work automatically unless you have set up FKs - perhaps that's obvious?

[vishalkr]

You have to follow this link and the instruction of this link to delete record from multiple tables:http://www.codeproject.com/Questions/619451/How-to-delete-records-in-multiple-tables-in-mysql