Mysql学习MySQL中安装样本数据库Sakila过程分享
|
《Mysql学习MySQL中安装样本数据库Sakila过程分享》要点： MYSQL学习通常情况下对于一个全新的MySQL服务器,没有任何数据供我们测试和使用.对此,MySQL为我们提供了一些样本数据库,我们可以基于这些数据库作基本的操作以及压力测试等等.本文描述的是安装sakila数据库.该数据库必要安装在MySQL 5.0以上的版本.以下是其描述. MYSQL进修1、下载种子数据库 MYSQL学习下载地位：http://dev.mysql.com/doc/index-other.html MYSQL进修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. MYSQL进修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. MYSQL学习3、验证安装成果 代码以下:[root@localhost sakila-db]# mysql root@localhost[(none)]> show databases; +--------------------+ | Database?????????? | +--------------------+ | information_schema | | mysql????????????? | | performance_schema | | sakila???????????? | | scottdb??????????? | | tempdb???????????? | | test?????????????? | +--------------------+ 7 rows in set (0.01 sec) root@localhost[(none)]> use sakila Database changed root@localhost[sakila]> 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) root@localhost[sakila]> select count(*) from customer; +----------+ | count(*) | +----------+ |????? 599 | +----------+ 1 row in set (0.01 sec) 《Mysql学习MySQL中安装样本数据库Sakila过程分享》是否对您有启发，欢迎查看更多与《Mysql学习MySQL中安装样本数据库Sakila过程分享》相关教程，学精学透。编程之家PHP学院为您提供精彩教程。 （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |