1.建表

CREATE TABLE `tb` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

2.数据库存储过程

-- 查询过程

create PROCEDURE get_name()
begin 
select * from tb;
end;

call get_name()


-- 修改过程
create PROCEDURE change_name(in name2 VARCHAR(255),in i2 INTEGER(11))
BEGIN 
UPDATE tb set name=name2 where id=i2;
end;

call change_name('mysql',7)


-- 删除过程,并且返回删除id的name列
create PROCEDURE del_name(in i2 INTEGER(11))
begin 
select name from tb where id=i2;
delete from tb where id=i2;
end;

call del_name(1)


-- 插入过程
create PROCEDURE insert_name(in name VARCHAR(255))
begin 
insert into tb(name) values(name);
end;

call insert_name('php')

原创文章，转载请注明出处：http://124.221.219.47/article/mysqlproce/