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教程
声明:本网页内容旨在传播知识,若有侵权等问题请及时与本网联系,我们将在第一时间删除处理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
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