Mysql循环插入数据

初始化数据环境

如果存在将表删除（慎用）

DROP TABLE IF EXISTS `user`; 

初始化表

CREATE TABLE `user` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `pwd` VARCHAR(255) NOT NULL,
  `info` VARCHAR(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uni_name` (`name`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

其他基本命令

• 查看表

  DESC USER;
  SHOW FULL FIELDS FROM user;

• 查看表索引

  SHOW KEYS FROM USER;
  SHOW index FROM USER;

• 清空表

  DELETE FROM USER;

• 查看指定库中的PROCEDURE

  SELECT NAME FROM mysql.proc WHERE db = ‘test’ AND TYPE = ‘PROCEDURE’;

• 删除指定PROCEDURE

  DROP PROCEDURE IF EXISTS callback;

• 查看创建代码

  SHOW CREATE PROCEDURE callback;

  <