SQL CRUD操作

INSERT INTO テーブル名 (カラム1, カラム2, ...) VALUES (値1, 値2, ...);

SELECT カラム名 FROM テーブル名;

UPDATE テーブル名 SET カラム名1 = 値1, カラム名2 = 値2, ...

DELETE FROM テーブル名

mysql> SELECT * FROM bookstore.books WHERE price > 1500;

mysql> UPDATE bookstore.books SET price = 1200 WHERE price = 1000;

mysql> DELETE FROM bookstore.books WHERE title = "はじめてのCSS";