数据表的操作
创建表
Create table table_name (
Field1 type [完整性约束条件],
Field2 type,
…
Fieldn type
)[character set xxx]
查看创建表信息
Show create table table_name;
查看表信息
Desc table_name;
Select columns from table_name;
修改表结构:
Alter table table_name add column_name type [完整性约束] [first | after 字段名];
Alter table table_name modify column_name type [完整性约束] [first | after 字段名];
Alter table table_name change column_name new_name type [完整性约束] [first | after 字段名];
Alert table table_name drop column_name;
Rename table table_name to new_name;
Drop table table_name;