题海让大学四年没有难题
白天模式登陆

题目详情

填空题 【异常处理】看代码,写出运行后表中有几条记录( )? -- 若存在表student,则删除DROP TABLE IF EXISTS student; -- 创建表student(学号id、姓名name、性别sex)CREATE TABLE student( id INT(10) PRIMARY KEY NOT NULL UNIQUE auto_increment, name VARCHAR(20) NOT NULL, sex CHAR(2))ENGINE=INNODB CHARACTER SET utf8; -- student插入记录INSERT INTO student VALUE (1,'姚朗','男');INSERT INTO student VALUE (2,'陈雲磊','男'); -- 若存在存储过程sp_insert_student,则删除DROP PROCEDURE IF EXISTS sp_insert_student; -- 创建存储过程sp_insert_student,插入三条记录delimiter $$CREATE PROCEDURE sp_insert_student()BEGIN -- 处理错误,当遇到错误(主键重复),忽略当前错误,继续执行下一调命令,同时给@a赋值 DECLARE CONTINUE HANDLER FOR 1062 set @a='主键重复'; INSERT INTO student(id,name,sex) VALUE (3,'张三','男'); INSERT INTO student(id,name,sex) VALUE (3,'李四','女'); INSERT INTO student(id,name,sex) VALUE (5,'王五','男');END $$delimiter ; -- 调用存储过程CALL sp_insert_student(); -- 查看student记录SELECT * FROM student

学科:数据库高级应用 v4.0

时间:2023-09-20 02:54:29

Copyright © 2022 津ICP备2021001502号