レコードの挿入
|
1 2 3 4 5 6 7 8 9 10 |
> 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) |