摘要：
创建一个简单的存储过程（示例）DELIMITER $$DROP PROCEDURE IF EXISTS TEST1$$CREATE DEFINER=`root`@`localhost` PROCEDURE TEST1()BEGIN DECLARE i int(4); DECLARE str varchar(100); SET i = 1; SET str = 'ag||gs||fg||fs'; UPDATE `testdb`.`tb` SET `msg` = str WHERE `tb`.`id` = 1;END$$DELIMITER ;CALL TEST1();... 阅读全文