端くれプログラマの備忘録 MySQL [MySQL] 基本メモ: レコードの挿入

[MySQL] 基本メモ: レコードの挿入

レコードの挿入

> insert into users (name, email, password, score, memo, created)
values ('yamada', 'yamada@example.com', 'password', 10, 'test memo', '2015-05-01 01:23:45');

> select * from users;
+------+--------+--------------------+----------+-------+------+-----------+---------------------+
| id   | name   | email              | password | score | sex  | memo      | created             |
+------+--------+--------------------+----------+-------+------+-----------+---------------------+
| NULL | yamada | yamada@example.com | password |    10 | NULL | test memo | 2015-05-01 01:23:45 |
+------+--------+--------------------+----------+-------+------+-----------+---------------------+
1 row in set (0.00 sec)