数据库编程
SQL语言
创建数据库:create database dbname
删除数据库:drop database dbname
创建新表:create table tbname
根据已有的表创建新表:create table tbname like table_old
create table table_newas select col1,col2...from table_old
删除新表:drop table tbname
增加一个新列:alter table tbname add column colname type
添加主键:alter table tbname add primary key(colname)
删除主键:alter table tbname drop primary key(colname)
创建索引:create [unique] index index_nameon tablename(col1,col2....)
删除索引:drop index index_name
创建视图:create view viewname as select statement
删除视图:drop view viewname
选择:select * from table where 范围
插入:insert into table_name(field1,field2..) values(value1,value2...)
删除:delete from table_name where 范围
更新:update table_name set field=value1 where 范围
查找:select * from table_name where field1 like '%value%'
排序:select * from table_name order by field1,field2 desc
总数:select count * as totalname from table_name
求和:select sum(field) as sumname from table_name
平均:select avg(field) as avgname from table_name
最大:select max(field) as maxname from table_name