[SQL]ENUM

Sat Mar 29

Git practice

Author:Noritaka

Astro
**ENUM**

DROP TABLEIF EXISTS posts;
CREATE TABLE posts (
message VARCHAR(140),
likes INT,
category ENUM("Gadget", "Game", "Business")
);

--INSERT INTO posts (message, likes, category) VALUES
--('Thanks', 12, "Gadget"),
--('Arigato', 14, "Game"),
--('Merci', 10, "Business");

INSERT INTO posts (message, likes, category) VALUES
('Thanks', 12, 1),
('Arigato', 14, 2),
('Merci', 10, 3);

SELECT * FROM posts;

SQL