SQL语言经典.docxVIP

创建数据库CREATE DATABASE database-name?删除数据库drop database dbname创建新表create table tabname(col1 type1 [not null] [primary key],col2 type2 [not null],..)删除新表drop table tabname?增加一个列Alter table tabname add column col type添加主键：?Alter table tabname add primary key(col)?创建索引：create [unique] index idxname on tabname(col….)?创建视图：create view viewname as select statement?删除视图：drop view viewname选择：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%’ --