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
You could use foreign keys constraints:
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?
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.