Shulou(Shulou.com)06/01 Report--

This article shows how to write delete statements in mysql database, and the code is concise and easy to understand, if you encounter this doubt in your daily work. I hope you can find a solution to your questions through this article.

The syntax of the delete statement:

DELETE FROM table_name [WHERE Clause]

Example:

Delete records with an id of 3 in the tbl table

Mysql > use TB;Database changedmysql > DELETE FROM tbl WHERE id=3;Query OK, 1 row affected (0.23 sec)

On the mysql database delete statement writing method to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you like this article, you might as well share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.