沈阳企业网站开发,网站每月流量,wordpress下载类模板,体验营销理论mysql查看索引与存储过程创建索引:CREATE INDEX可对表增加普通索引或UNIQUE唯一索引。CREATE INDEX index_name ON table_name (column_list)CREATE UNIQUE INDEX index_name ON table_name (column_list)ALTER TABLE用来创建普通索引、UNIQUE索引或PRIMARY KEY主键。ALTER TAB…mysql查看索引与存储过程创建索引:CREATE INDEX可对表增加普通索引或UNIQUE唯一索引。CREATE INDEX index_name ON table_name (column_list)CREATE UNIQUE INDEX index_name ON table_name (column_list)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 ADD PRIMARY KEY (column_list)查看索引mysql show index from tablename;mysql show keys from tablename;Non_unique 唯一约束为0。非唯一约束为1。删除索引可利用ALTER TABLE或DROP INDEX语句来删除索引DROP INDEX index_name ON talbe_nameALTER TABLE table_name DROP INDEX index_nameALTER TABLE table_name DROP PRIMARY KEY查询数据库的存储过程:select name from mysql.proc where db db_name and type PROCEDURE或者show procedure status查看函数:select name from mysql.proc where db db_name and type function或者show function status查看存储过程与函数内容:show create procedure proc_name;show create function func_name;如果需要修改存储过程与函数,先drop 再create.其它数据库参数查看:mysql help show mysql Show Global Status, mysql Show global variables, mysql Show full processlist, mysql show engines; mysql show status; mysql desc tablename; mysql show databases; mysql use database_name;
