从数据库中删除数据 delete
插入数据 insert into
创建新数据库 create database
修改数据库 alter database
创建新表 create table
变更数据库表 alter table
删除表 drop table
创建索引 create index
删除索引 drop index
查找所有列 select * from table
查找列中不同值 select distinct name from table
select * from table where city = 'beijing'
order by 字段名 默认升序(desc 降序)
update person set address = 'zhengzhou', city = 'beijing' where lastName = 'xiaocao'
delete from person where lastName = 'xiaocao'
select * from persons where lastName in('adms','carter');
select column_name(s) from table_name where column_name between value1 and value2
插入数据 insert into
创建新数据库 create database
修改数据库 alter database
创建新表 create table
变更数据库表 alter table
删除表 drop table
创建索引 create index
删除索引 drop index
查找所有列 select * from table
查找列中不同值 select distinct name from table
select * from table where city = 'beijing'
order by 字段名 默认升序(desc 降序)
update person set address = 'zhengzhou', city = 'beijing' where lastName = 'xiaocao'
delete from person where lastName = 'xiaocao'
select * from persons where lastName in('adms','carter');
select column_name(s) from table_name where column_name between value1 and value2