| 标题 | mysql中安装样本数据库sakila过程分享 |
| 范文 | 通常情况下对于一个全新的mysql服务器，没有任何数据供我们测试和使用。对此，mysql为我们提供了一些样本数据库，我们可以基于这些数据库作基本的操作以及压力测试等等。本文描述的是安装sakila数据库。该数据库需要安装在mysql 5.0以上的版本。以下是其描述。 1、下载种子数据库 下载位置：> 2、安装种子数据库sakila 代码如下: [root@localhost ~]# unzip sakila-db.zip archive: sakila-db.zip creating: sakila-db/ inflating: sakila-db/sakila-schema.sql inflating: sakila-db/sakila.mwb inflating: sakila-db/sakila-data.sql the sakila-schema.sql file contains all the create statements required to create the structure of the sakila database including tables, views, stored procedures, and triggers. the sakila-data.sql file contains the insert statements required to populate the structure created by the sakila-schema.sql file, along with definitions for triggers that must be created after the initial data load. the sakila.mwb file is a mysql workbench data model that you can open within mysql workbench to examine the database structure. for more information, see mysql workbench. [root@localhost ~]# ls anaconda-ks.cfg desktop install.log install.log.syslog sakila-db sakila-db.zip [root@localhost ~]# cd sakila-db [root@localhost sakila-db]# ls sakila-data.sql sakila.mwb sakila-schema.sql [root@localhost sakila-db]# mysql -uroot -p <sakila-schema.sql enter password: [root@localhost sakila-db]# mysql -uroot -p <sakila-data.sql enter password: 3、验证安装结果 代码如下: [root@localhost sakila-db]# mysql )]> show databases; +--------------------+ | database | +--------------------+ | information_schema | | mysql | | performance_schema | | sakila | | scottdb | | tempdb | | test | +--------------------+ 7 rows in set (0.01 sec) )]> use sakila database changed ]> show tables; +----------------------------+ | tables_in_sakila | +----------------------------+ | actor | | actor_info | | address | | category | | city | | country | | customer | | customer_list | | film | | film_actor | | film_category | | film_list | | film_text | | inventory | | language | | nicer_but_slower_film_list | | payment | | rental | | sales_by_film_category | | sales_by_store | | staff | | staff_list | | store | +----------------------------+ 23 rows in set (0.00 sec) ]> select count(*) from customer; +----------+ | count(*) | +----------+ | 599 | +----------+ 1 row in set (0.01 sec) |
| 随便看 |
|
在线学习网范文大全提供好词好句、学习总结、工作总结、演讲稿等写作素材及范文模板，是学习及工作的有利工具。