できるPRO MySQL できるPROシリーズ Kindle版の内容をまとめる。
DEFAULT
CREATE TABLE meals (
user_id INT,
meat VARCHAR(16) DEFAULT 'chicken'
);
MariaDB [dekirusample2]> CREATE TABLE meals (user_id INT,meat VARCHAR(16) DEFAULT 'chicken');
Query OK, 0 rows affected (0.07 sec)
INSERT INTO meals(user_id, meat) VALUES (0,'beef');
MariaDB [dekirusample2]> INSERT INTO meals(user_id, meat) VALUES (0,'beef');
Query OK, 1 row affected (0.01 sec)
INSERT INTO meals(user_id) VALUES (1);
MariaDB [dekirusample2]> INSERT INTO meals(user_id) VALUES (1);
Query OK, 1 row affected (0.01 sec)
SELECT * FROM meals;
MariaDB [dekirusample2]> SELECT * FROM meals;
+---------+---------+
| user_id | meat |
+---------+---------+
| 0 | beef |
| 1 | chicken |
+---------+---------+
2 rows in set (0.00 sec)