MySql的添加存盤程序
DROP PROCEDURE IF EXISTS aaa; /*洗掉存盤程序*/
DELIMITER $ /*自定義結束符號為$*/
CREATE PROCEDURE aaa() /*創建存盤程序aaa*/
BEGIN /*開始*/
DECLARE i INT DEFAULT 1;/*初始化i為1*/
START TRANSACTION;/*可有可無 */
WHILE i <= 100 DO /*回圈次數*/
INSERT INTO student (name, sex, email) VALUES (concat('javacode',i),if(mod(i,2),1,2),concat('javacode',i,'@163.com'));
SET i = i + 1; /*相當于for回圈得i++*/
if i%10=0 THEN /*if判斷*/
COMMIT;
START TRANSACTION;
END IF;/*if判斷結束*/
END WHILE;/*回圈結束*/
COMMIT;/*提交*/
END $/*結束*/
DELIMITER ; /*結束符號改成;*/
CALL aaa(); /* 啟動存盤程序 */
MySql得查詢存盤程序
不帶引數
/*user1如果存在的話就會被洗掉*/
DROP PROCEDURE IF EXISTS student1;
create PROCEDURE student1()
begin
select * from student;
end;
CALL student1();
帶引數
DROP PROCEDURE IF EXISTS student2;
create PROCEDURE student2(IN id1 int)
begin
select * from student where id = id1;
end;
CALL student2(57); /*執行student1*/
MySql得洗掉存盤程序
傳值
DROP PROCEDURE IF EXISTS student3;
create PROCEDURE student3(IN id1 int)
begin
delete from student where id = id1;
end;
CALL student3(57); /*執行student1*/
初始化值
DROP PROCEDURE IF EXISTS student3;
create PROCEDURE student3()
begin
DECLARE id1 INT DEFAULT 56;/*初始化id1為56*/
delete from student where id = id1;
end;
CALL student3(); /*執行student3*/
MySql得修改存盤程序
DROP PROCEDURE IF EXISTS student4;
create PROCEDURE student4(IN id1 INT,IN name1 VARCHAR(255) )
begin
update student set name = name1 where id = id1;
end;
CALL student4(50,"哈哈哈"); /*執行student1*/
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/196482.html
標籤：區塊鏈