【MySQL】よく使うコマンド

はじめに

select以外をよく忘れるのでメモ

SQL

UPDATE

UPDATE table SET column = value WHERE id = 1;

INSERT

INSERT INTO table(column1, column2) VALUES("NEKO", true);

DELETE

DELETE FROM table WHERE id = 1;

SELECT

SELECT * FROM table WHERE id = 1;