存储过程
#注意这是在navicat中编写
create procedure insert_user()
BEGIN
#Routine body goes here...
declare n bigint;
set n = 1;
while n <= 10
do
insert into user(id) values(n);
set n = n + 1;
end while;
END;
触发器
触发器可以写日志等等。
create trigger auto_user_number after insert on user for each row
begin
update number
set user_number = (select count(*) from user) where id = 1;
end
注意:在命令行中编写触发器和存储过程时,需要注意结束符
定义结束符
DELIMITER ||
在结束存储过程及触发器编写时需要将结束符修改回 ;