建表
create table <table_name>(
column_name1 column_type [not null] [check (expression)]
[default value] [primary key][references <table_name>(column_name)],
column_name2 column_type [not null] [check (expression)]
[default value] [primary key][references <table_name>(column_name)]
....
[constraint primary_name
primary key(column_name1,column_name2...)
]
[unique(<column_name1,column_name2...>)]
);
create table <table_name>
as
select * from <other_table_name> where <condition>
---------------------------------------------------------------------------------------
改表结构
1 alter table <table_name> add(column_name column_type);
2 alter table <table_name> modify(column_naem column_type);
---------------------------------------------------------------------------------------
删表
drop table <table_name>;
truncate table <table_name>;
---------------------------------------------------------------------------------------
表的重命名
rename <table_name1> to <table_name2>;
---------------------------------------------------------------------------------------
插入数据
1 insert into <table_name> (column_name1, column_name2, ....)
values (column_value1, column_value2,.... );
2 insert into <table_name>
values (column_value1, column_value2,.... );
3 insert into <table_name> (column_name1, column_name2, ....)
select expression1,expression2, ....
from <table_name>
[where <condition_expression>];
---------------------------------------------------------------------------------------
表�
