Tags
MySQL
Asked 7 years ago
6 Oct 2017
Views 821
sqltreat

sqltreat posted

How to delete multiple record with single query in MySQL Database ?

How to delete multiple record with single query in MySQL Database
i have two table , table1 and table2 primary key of table1 is foreign key in table2 . i want to delete table one record but first we must delete all record present in table2 that relate to table1 record

delete table1,table2 where id=1

is work like this ?
Post Answer