How to implement batch deletion in mysql

Mysql method to implement batch deletion: use sql to implement batch deletion of data, the code is [DELETE "field name" FROM "table name" WHERE "field name" IN ('value one', 'value two ', ...);].

Mysql method to implement batch deletion:

sql syntax for deleting a data:

DELETE "栏位名" 
FROM "表格名" 
WHERE "栏位名" = '值';

Example:

DELETE * from formName where "name" = 'jack';

sqlBatchDelete data syntax:

DELETE "栏位名" 
FROM "表格名" 
WHERE "栏位名" IN ('值一', '值二', ...);

Example:

DELETE * from formName where "name" in ('jack','rose','tom');

More related free learning recommendations: mysql tutorial(view frequency)

The above is the detailed content of How to implement batch deletion in mysql. For more information, please follow other related articles on the PHP Chinese website!