Sql入门

快速提醒！！！

创建数据库create database database_name(.......)

删除数据库drop databasedatabase_name

创建表create table table_name(.......)

删除表drop table table_name

查询

select[distinct] column1,column2......

fromtable_name

join join_condition

where search_conditon

group by condition

having search_condition

order by order_expressionASC|DESC

插入数据insert into table_name[(.......)]values(values1,values2.......)

更新数据update table_nameset newvaluewhere search_condition

删除数据delete from table_namewhere search_condition

创建视图

create view view_name(column1,column2......)as select column1,column2.......from table_namewhere search_conditon

删除视图drop view view_name