首先创建一张 students 表
SQL脚本如下:
create table students( id int primary key auto_increment, age int, name varchar(20), city varchar(20) ) character set utf8; insert into students values(null, 22, 'lisa', '杭州'); insert into students values(null, 16, 'rock', '上海'); insert into students values(null, 20, 'jack', '深圳'); insert into students values(null, 21, 'rose', '北京');
不带参数的存储过程
-- 查询学生个数 drop procedure if exists select_students_count; delimiter ;; -- 替换分隔符 create procedure select_students_count() begin select count(id) from students; end ;; delimiter ;
执行存储过程:
call select_students_count();
带参数的存储过程
50000+
5万行代码练就真实本领
17年
创办于2008年老牌培训机构
1000+
合作企业
98%
就业率