create procedure test_del( IN in_sno char (6) )
BEGIN
DECLARE v_result char (10) DEFAULT NULL;
DELETE o1,t2
FROM
student AS o1
LEFT OUTER JOIN grade AS t2 ON t2.sno= o1.sno
WHERE
o1.sno =in_sno;
END
create procedure test_del( IN in_sno char (6) )
BEGIN
DECLARE v_result char (10) DEFAULT NULL;
DELETE o1,t2
FROM
student AS o1
LEFT OUTER JOIN grade AS t2 ON t2.sno= o1.sno
WHERE
o1.sno =in_sno;
END