· 7 years ago · Nov 21, 2018, 08:02 AM
1create table if not exists Ditte(nome varchar(30), luogo varchar(30), ZIP int);
2
3delimiter //
4create procedure deleteDitta(zip int)
5begin
6DECLARE newZIP int;
7SET newZIP = zip;
8DELETE from Ditte where ZIP = newZIP;
9end;
10//
11delimiter ;
12
13insert ignore into Ditte values ("Ditta1", "city1", 6828);
14insert ignore into Ditte values ("Ditta2", "city2", 12345);
15
16create procedure deleteDitta(dzip int)
17begin
18 DELETE from Ditte where ZIP = dzip;
19end;