[SQL]SQL basic

Tue Mar 25

Git practice

Author：Noritaka

basic

DROP TABLE IF EXISTS posts;
CREATE TABLE posts (
message VARCHAR(140),
likes INT
);

DESC posts;

SHOW TABLES;

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

SELECT * FROM posts;