一、索引:
查看索引:
SHOW INDEX FROM tablename;
SHOW KEYS FROM tablename;
创建索引:
// 1-alert方法
ALTER TABLE tablename ADD INDEX index_name(column_list);
ALTER TABLE tablename ADD UNIQUE INDEX index_name(column_list);
// 2-create方法
CREATE INDEX index_name ON tablename (column_list);
CREATE UNIQUE INDEX index_name ON tablename (column_list);
删除索引:
DROP INDEX index_name ON tablename;
ALTER TABLE tablename DROP INDEX index_name;
ALTER TABLE tablename DROP PRIMARY KEY;
查看表:
// 查看建表语句
SHOW CREATE TABLE tablename;
// 查看表详情
DESC tablename;
SHOW COLUMNS FROM ticket_columns_setting;