mysql表复制
复制表结构+复制表数据
| mysql> create table t3 like t1; mysql> insert into t3 select * from t1; |
mysql索引
| ALTER TABLE用来创建普通索引、UNIQUE索引或PRIMARY KEY索引 ALTER TABLE table_name ADD INDEX index_name (column_list) ALTER TABLE table_name ADD UNIQUE (column_list) ALTER TABLE table_name ADDPRIMARY KEY (column_list) Create Index CREATE INDEX index_name ON table_name (column_list) CREATE UNIQUE INDEX index_name ON table_name (column_list) drop index DROP INDEX index_name ON talbe_name alter table table drop ALTER TABLE table_name DROP INDEX index_name ALTER TABLE table_name DROP PRIMARY KEY |
mysql视图
创建视图
| mysql> create view v_t1 as select * from t1 where id>4 and id<11; Query OK, 0 rows affected (0.00 sec) |
view视图的帮助信息
| mysql> ? view ALTER VIEW CREATE VIEW DROP VIEW |
查看视图
| mysql> show tables; |
删除视图v_t1
| mysql> drop view v_t1; |
mysql内置函数
