if-not-exists is a common SQL condition used to check if an entity exists.
IF NOT EXIST conditions are used in WHERE clauses, in IF statements and in conditional creation of entities, e.g.:
CREATE TABLE IF NOT EXISTS cars(
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
maker VARCHAR(30),
model VARCHAR(30));
|
created |
11 years ago |
|
viewed |
7 times |
|
active |
11 years ago |
|
editors |
1 |
