[SQL]AUTO INCREMENT, PRIMARY KEY

Sat Mar 29

Git practice

Author：Noritaka

**AUTO_INCREMENT**
**PRIMARY KEY**

DROP TABLE IF EXISTS posts;
CREATE TABLE posts (
	id INT NOT NULL AUTO_INCREMENT,
	message VARCHAR(140) UNIQUE,
	like INT (likes >= 0 AND likes <= 100),
	PRIMARY KEY (id)
);

--INSERT INTO posts (message, likes) VALUES
	--(1, 'Thanks', 12),
	--(2, 'Arigato', 4),
	--(3, 'Merci', 4);

INSERT INTO posts (message, likes) VALUES
	('Thanks', 12),
	('Arigato', 4),
	('Merci', 4);

INSERT INTO posts (message) VALUES ('Gracias');

SELECT * FROM posts;