初始化数据环境
如果存在将表删除(慎用)
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;
<