面试准备-数据库编程

数据库编程

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