mysql表復(fù)制
復(fù)制表結(jié)構(gòu)+復(fù)制表數(shù)據(jù)
| mysql> create table t3 like t1;mysql> insert into t3 select * from t1; |
mysql索引
| ALTER TABLE用來創(chuàng)建普通索引、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 IndexCREATE INDEX index_name ON table_name (column_list)CREATE UNIQUE INDEX index_name ON table_name (column_list)drop indexDROP INDEX index_name ON talbe_namealter table table dropALTER TABLE table_name DROP INDEX index_nameALTER TABLE table_name DROP PRIMARY KEY |
mysql視圖
創(chuàng)建視圖
| 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> ? viewALTER VIEWCREATE VIEWDROP VIEW |
查看視圖
| mysql> show tables; |
刪除視圖v_t1
| mysql> drop view v_t1; |
mysql內(nèi)置函數(shù)
新聞熱點
疑難解答
圖片精選
