mysql官方world数据库city、country表t100w数据库及表，oldguo老师案例数据库

最新推荐文章于 2025-01-08 12:00:00 发布

ty3251778

最新推荐文章于 2025-01-08 12:00:00 发布

阅读量1.8k

点赞数

分类专栏： linux mysql

本文链接：https://blog.youkuaiyun.com/ty3251778/article/details/115861730

版权

linux 同时被 2 个专栏收录

2 篇文章

订阅专栏

mysql

1 篇文章

订阅专栏

本文提供了MySQL官方world数据库中city和country表的详细信息，包括数据下载链接，便于读者进行学习和实践。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql官方world数据库city、country表

完整版

mysql> use world;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-----------------+
| Tables_in_world |
+-----------------+
| city            |
| country         |
| countrylanguage |
+-----------------+
3 rows in set (0.00 sec)

mysql> desc city;
+-------------+----------+------+-----+---------+----------------+
| Field       | Type     | Null | Key | Default | Extra          |
+-------------+----------+------+-----+---------+----------------+
| ID          | int(11)  | NO   | PRI | NULL    | auto_increment |
| Name        | char(35) | NO   |     |         |                |
| CountryCode | char(3)  | NO   | MUL |         |                |
| District    | char(20) | NO   |     |         |                |
| Population  | int(11)  | NO   |     | 0       |                |
+-------------+----------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

mysql>

mysql> use test;
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| t100w          |
+----------------+
1 row in set (0.00 sec)

mysql> desc t100w;
+-------+-----------+------+-----+-------------------+-----------------------------+
| Field | Type      | Null | Key | Default           | Extra                       |
+-------+-----------+------+-----+-------------------+-----------------------------+
| id    | int(11)   | YES  | MUL | NULL              |                             |
| num   | int(11)   | YES  |     | NULL              |                             |
| k1    | char(2)   | YES  |     | NULL              |                             |
| k2    | char(4)   | YES  | MUL | NULL              |                             |
| dt    | timestamp | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+-------+-----------+------+-----+-------------------+-----------------------------+
5 rows in set (0.00 sec)

mysql> select count(id) from t100w;
+-----------+
| count(id) |
+-----------+
|   1000000 |
+-----------+
1 row in set (1.65 sec)

mysql>