MySQLのサンプルデータベースのテーブル定義
いつも忘れるのでメモ
mysql-sql> use world_x; Query OK, 0 rows affected (0.01 sec) mysql-sql> show tables; +-------------------+ | Tables_in_world_x | +-------------------+ | city | | country | | countryinfo | | countrylanguage | +-------------------+ 4 rows in set (0.01 sec) mysql-sql> desc city; +-------------+----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+----------+------+-----+---------+----------------+ | ID | int(11) | NO | PRI | null | auto_increment | | Name | char(35) | NO | | | | | CountryCode | char(3) | NO | | | | | District | char(20) | NO | | | | | Info | json | YES | | null | | +-------------+----------+------+-----+---------+----------------+ 5 rows in set (0.09 sec) mysql-sql> desc country; +---------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+----------+------+-----+---------+-------+ | Code | char(3) | NO | PRI | | | | Name | char(52) | NO | | | | | Capital | int(11) | YES | | null | | | Code2 | char(2) | NO | | | | +---------+----------+------+-----+---------+-------+ 4 rows in set (0.01 sec) mysql-sql> desc countryinfo; +-------+-------------+------+-----+---------+------------------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+------------------+ | doc | json | YES | | null | | | _id | varchar(32) | NO | PRI | null | STORED GENERATED | +-------+-------------+------+-----+---------+------------------+ 2 rows in set (0.01 sec) mysql-sql> desc countrylanguage; +-------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+---------------+------+-----+---------+-------+ | CountryCode | char(3) | NO | PRI | | | | Language | char(30) | NO | PRI | | | | IsOfficial | enum('T','F') | NO | | F | | | Percentage | float(4,1) | NO | | 0.0 | | +-------------+---------------+------+-----+---------+-------+ 4 rows in set (0.01 sec) mysql-sql>