定义存储过程:
DELIMITER $$
DROP PROCEDURE
IF EXISTS pro_up_base_info$$
CREATE PROCEDURE pro_up_base_info (
IN t_org_no VARCHAR (32)
out t_out varchar(32)
)
BEGIN
//中件内容具体的变量定义,语句等等
END$$
DELIMITER ;
语法定义:
//定义varchar变量
DECLARE t_table_name VARCHAR (32) ;
//定义 int变量,默认值
DECLARE col_num, no_more_res INT DEFAULT 0 ;
//定义游标
DECLARE tab_names CURSOR FOR SELECT table_name FROM information_schema.`TABLES`
//遍历游标,如果到达末行设置标识
DECLARE CONTINUE HANDLER FOR NOT FOUND SET no_more_res = 1 ;
//打开游标
OPEN tab_names ;
//读取游标值
FETCH tab_names INTO t_table_name ;
//循环遍历
WHILE no_more_res <> 1 DO
SELECT
count(*) INTO col_num
FROM
information_schema. COLUMNS
WHERE