数据库sql语句

sql語句

获取表中的总行数
select count(*) from table_name;

计算满足特定条件的记录数
select count(*) from table_name where condition;

查询表中所有数据
select * from table_name;

查询特定列的数据
select column1 column2 from table_name;

条件查询
select * from table_name where conditon;

按照条件排序
select * from table_name order by column_name;

限制返回行数
select * from table_name limit 10;

计算表中某列的总和
select sum(column_name) from table_name；

基本语句

/插入数据
insert into table_name (column1,column2) values (value1,value2);

删除数据
delete from table_name where conditon;

创建表
create table table_name(
	column1 datatype1 constraints,
	...
);

删除表
drop table table_name;

修改表的结构
alter table table_name add column_name datatype;

查询唯一值
select distinct column_name from table_name;