delete multiple records in single query

by Ramya 2012-07-05 18:30:42

delete multiple records in single query

you can delete multiple records from a table using single query in mysql,
delete from table where fieldname IN()


for eg,
delete from statval where type IN ('value','value')

Razz
Razz
1128
like
0
dislike
0
mail
flag

You must LOGIN to add comments