数据库循环输入数值

数据库源码

DROP PROCEDURE IF EXISTS proc_initData;
DELIMITER $
CREATE PROCEDURE proc_initData()
BEGIN
DECLARE i INT DEFAULT 21;
WHILE i<=30 DO
INSERT INTO sqlText values(i,‘bb’,1);
SET i = i+1;
END WHILE;
END $
CALL proc_initData();

添加索引

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 )
1．ALTER TABLE
ALTER TABLE用来创建普通索引、UNIQUE索引或PRIMARY KEY索引。
1.ALTER TABLE table_name ADD INDEX index_name (column_list)

2.ALTER TABLE table_name ADD UNIQUE (column_list)

3.ALTER TABLE table_name ADD PRIMARY KEY (column_list)