SQL CONSTRAINTS

Question 1

How to create a table that doesn’t allow specific values?

Answer 1

create table samples(coin varchar(10) CHECK (coin IN (‘a’, ‘b’, ‘c’)));

Question 2

How to use a transaction?

Answer 2

START TRANSACTION;
# do something
COMMIT; # if ok
ROLLBACK; # if not ok