Mysql sql 手记

1:查看数据库存储过程sql
show procedure status
附上地址：https://blog.csdn.net/nangeali/article/details/76285392
2:根据名称查看存储过程内容
show create procedure procedure_name
3:查看数据表索引
show index from order_info
4:删除存储过程：
DROP PROCEDURE test_insert
5：创建一个存储过程：
DELIMITER ;;
CREATE PROCEDURE test_insert ()
BEGIN

DECLARE i INT DEFAULT 1;

WHILE i<1000
DO
INSERT INTO elle_transin VALUES (‘1234566563432’, ‘14314’, ‘’, ‘’, ‘2018-09-26 16:35:44’, ‘’, ‘2018-09-26 16:35:40’, ‘2018-09-27 16:35:20’, ‘3232412’, ‘Sun’, ‘441324324’, ‘4124144’, ‘1431242’, ‘1243214’, ‘12412423424’, ‘2018-09-26 16:36:15’, ‘加数据’, ‘777’, ‘1’, ‘421432141243’, ‘elle’, ‘elle’, ‘22131’, ‘15937865558’, ‘15937865558’, ‘15937865558@qq.com’, ‘1434’, ‘河南’, ‘郑州’, ‘华北区’, ‘许昌镇’, ‘河南省许昌县’, ‘elle’, ‘david’, ‘2313’, ‘15937865558’, ‘15937865558’, ‘15937865558’, ‘1’, ‘15937865558’, ‘3333232313’, '4324 ', ‘许昌’, ‘华北’, ‘许村镇’, ‘河南省许昌县’, ‘32432’, ‘3434’, ‘d4343’, ‘343443’, ‘343’, ‘david’, ‘999’, ‘3434324’, ‘999.66’, ‘88.69’, ‘2’, ‘2018-09-26 16:39:13’, ‘2018-09-26 16:39:17’, ‘324242143’, ‘4332424’, ‘434242’, ‘2018-08-31 16:39:40’, ‘0’);
SET i=i+1;
END WHILE ;
commit;

END;;

mysql 静态表和非静态表的区别https://blog.csdn.net/erjian666/article/details/53043618