SQL CONSTRAINTS Flashcards
1
Q
How to create a table that doesn’t allow specific values?
A
create table samples(coin varchar(10) CHECK (coin IN (‘a’, ‘b’, ‘c’)));
2
Q
How to use a transaction?
A
START TRANSACTION;
# do something
COMMIT; # if ok
ROLLBACK; # if not ok
