mysql数据库的删除语句怎么写
来源:动视网
责编:小采
时间:2020-11-09 06:53:44
mysql数据库的删除语句怎么写
mysql数据库的删除语句怎么写:删除语句的语法:DELETE FROM table_name [WHERE Clause]实例:删除tbl 表中id 为3 的记录mysql> use TB; Database changed mysql> DELETE FROM tbl WHERE id=3; Query OK, 1 row affected (0.23 s
导读mysql数据库的删除语句怎么写:删除语句的语法:DELETE FROM table_name [WHERE Clause]实例:删除tbl 表中id 为3 的记录mysql> use TB; Database changed mysql> DELETE FROM tbl WHERE id=3; Query OK, 1 row affected (0.23 s

删除语句的语法:
DELETE FROM table_name [WHERE Clause]
实例:
删除tbl 表中id 为3 的记录
mysql> use TB;
Database changed
mysql> DELETE FROM tbl WHERE id=3;
Query OK, 1 row affected (0.23 sec)
推荐教程:mysql教程
mysql数据库的删除语句怎么写
mysql数据库的删除语句怎么写:删除语句的语法:DELETE FROM table_name [WHERE Clause]实例:删除tbl 表中id 为3 的记录mysql> use TB; Database changed mysql> DELETE FROM tbl WHERE id=3; Query OK, 1 row affected (0.23 s