How to delete Data from multiple tables.
For example Iam having category id in one data base table .in another data base table iam having this id if i delete category id it should display a message as first delete in that table if the id is there in that database then nor then it can delete.
Jump to Post
You can use
ON DELETE CASCADEoption in mysql
By using this, on deleting the record from parent table removes the records from child tables.
Please check this article for more details and for examples
All 3 Replies
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.