【20240805每日一题】数据库的增删改查

难度

简单

题目

数据库的增删改查去重命令是什么?

添加命令:
insert into table_name (column1, …) values (value1, …);

删除命令:
delete from table_name where condition;

修改命令:
update table_name set column1 = value1, column2 = value2, … where condition;

查询命令:
select column1, column2, … from table_name where condition;

去重命令:
select distinct column_name from table_name;

1 Like

Create, Read, Update, Delete
UNIQUE,DISTINCT,子查询与条件判断,子查询或JOIN操作

2 Likes