Syntax of delete statement:
DELETE FROM table_name [WHERE Clause]
Example:
Delete the record with id 3 in the tbl table
mysql> use TB; Database changed mysql> DELETE FROM tbl WHERE id=3; Query OK, 1 row affected (0.23 sec)
Recommended tutorial: mysql tutorial
The above is the detailed content of How to write the delete statement in mysql database. For more information, please follow other related articles on the PHP Chinese website!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
