diff options
| author | Sean <sb.groenenboom@student.avans.nl> | 2023-03-24 14:07:58 +0100 |
|---|---|---|
| committer | Sean <sb.groenenboom@student.avans.nl> | 2023-03-24 14:07:58 +0100 |
| commit | 3199b9ebfa707068fd2c901276e663b660d1a050 (patch) | |
| tree | eab034823fb94a5b749456925706becdf7c60214 /dbinit/procedures.sql | |
| parent | a48660843cc0191b62865b54f29bd9b230589a5e (diff) | |
Update procedures.sql
Diffstat (limited to 'dbinit/procedures.sql')
| -rw-r--r-- | dbinit/procedures.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/dbinit/procedures.sql b/dbinit/procedures.sql index b6b0042..73627c2 100644 --- a/dbinit/procedures.sql +++ b/dbinit/procedures.sql @@ -10,3 +10,14 @@ create procedure spUpdateFlags(imgPath varchar(255)) where `B`.`ID` = `A`.`ID`); end$$ delimiter ; + +drop procedure if exists spDeleteFlags; + +delimiter $$ +create procedure spDeleteFlags() + begin + update `nationality` + set `nationality`.`flag` = NULL + where `nationality`.`flag` is not NULL + end$$ +delimiter ; |