数据库学习杂记

数据库：

创建
CREATE DATABASE database-name
drop database dbname

create table tabname(col1 type1 [not null] [primary key],col2 type2 [not null],..)
drop table tabname

select * from table1 where …
insert into table1(field1,field2) values(value1,value2)
delete from table1 where…
update table1 set field1=value1 where…
select * from table1 where field1 like ’%value1%’
select * from table1 order by field1,field2 [desc]
select count as totalcount from table1
select sum(field1) as sumvalue from table1
select avg(field1) as avgvalue from table1
select max(field1) as maxvalue from table1
select min(field1) as minvalue from table1