.jpg)
本文主要和大家分享mysql創(chuàng)建索引和刪除索引的方法，希望能幫助到大家。
一.添加索引
(1)ALTER TABLE語(yǔ)句
1.PRIMARY??KEY（主鍵索引） ????????mysql>ALTER??TABLE??`table_name`??ADD??PRIMARY??KEY?(??`column`??)? 2.UNIQUE(唯一索引) ????????mysql>ALTER??TABLE??`table_name`??ADD??UNIQUE?(`column`?)? 3.INDEX(普通索引) ????????mysql>ALTER??TABLE??`table_name`??ADD??INDEX?index_name?(??`column`??) 4.FULLTEXT(全文索引) ????????mysql>ALTER??TABLE??`table_name`??ADD??FULLTEXT?(?`column`?) 5.多列索引 ????????mysql>ALTER??TABLE??`table_name`??ADD??INDEX?index_name?(??`column1`,??`column2`,??`column3`??)
(2)CREATE INDEX語(yǔ)句
1.UNIQUE(唯一索引) ????????mysql>CREATE?UNIQUE?INDEX?index_name?ON?`table_name`?(`column`?)? 2.INDEX(普通索引) ????????mysql>CREATE?INDEX?index_name?ON?`table_name`?(??`column`??) 3.多列索引 ????????mysql>CREATE?INDEX?index_name?ON?`table_name`?(??`column1`,??`column2`,??`column3`??)
二.刪除索引
1.PRIMARY??KEY（主鍵索引） ????????mysql>ALTER??TABLE??`table_name`??DROP?PRIMARY?KEY? 3.INDEX(普通索引)或UNIQUE(唯一索引) ????????mysql>ALTER??TABLE??`table_name`??DROP?INDEX?index_name ????????mysql>DROP?INDEX?index_name?ON?`talbe_name`
相關(guān)推薦：
MySQL中兩表關(guān)聯(lián)的連接表如何創(chuàng)建索引圖文詳解
? 版權(quán)聲明
文章版權(quán)歸作者所有，未經(jīng)允許請(qǐng)勿轉(zhuǎn)載。
THE END
.png)
