Mysql從入門到入魔——1. 數據準備（起航篇建議收藏）

寫在前面

參考書籍：《SQL必知必會》《Mysql必知必會》

實習將至，最近在復習 Mysql ，之前學習 Mysql 是通過視頻和學校課程，這次想通過書籍《SQL必知必會》來進行一次系統的復習，再重新快速的刷一遍牛客網的 SQL 題。在復習的過程中我會將重要內容進行記錄，其中難以理解的部分也會通過典型的案例進行展示，希望能夠幫到大家。

本篇主要內容

“實踐是檢驗真理的唯一標準”，我總認為動手做比只空想更好，那么為了之后的學習能夠一步一個腳印的學懂，首先要把示例數據導入本地 Mysql 中。本篇主要介紹如何導入數據文件，同時展示各表的結構和數據。

數據準備

1. Navicat中新建數據庫

數據文件：網盤鏈接

提取碼：rtbg

創建 order_system 數據庫 ---- 新建查詢----將文件內容復制并執行。

2. Mysql中導入sql文件新建數據庫

首先新建 order_system 數據庫。

命令行導入 create.sql 文件

mysql -u root -p order_system < C:\Users\pc\Desktop\Mysql\create.sql

命令行導入 populate.sql 文件

mysql -u root -p order_system < C:\Users\pc\Desktop\Mysql\populate.sql

3. 各表結構

Customers 表

Orders 表

OrderItems 表

Products 表

Vendors 表

各表關系圖

4. 各表數據

Customers 表

mysql> SELECT * FROM customers; +------------+---------------+----------------------+-----------+------------+----------+--------------+ | cust_id | cust_name | cust_address | cust_city | cust_state | cust_zip | cust_country | +------------+---------------+----------------------+-----------+------------+----------+--------------+ | 1000000001 | Village Toys | 200 Maple Lane | Detroit | MI | 44444 | USA | | 1000000002 | Kids Place | 333 South Lake Drive | Columbus | OH | 43333 | USA | | 1000000003 | Fun4All | 1 Sunny Place | Muncie | IN | 42222 | USA | | 1000000004 | Fun4All | 829 Riverside Drive | Phoenix | AZ | 88888 | USA | | 1000000005 | The Toy Store | 4545 53rd Street | Chicago | IL | 54545 | USA | +------------+---------------+----------------------+-----------+------------+----------+--------------+ --------------------+-----------------------+ cust_contact | cust_email | --------------------+-----------------------+ John Smith | sales@villagetoys.com | Michelle Green | NULL | Jim Jones | jjones@fun4all.com | Denise L. Stephens | dstephens@fun4all.com | Kim Howard | NULL | --------------------+-----------------------+

Orderitems 表

mysql> SELECT * FROM orderitems; +-----------+------------+---------+----------+------------+ | order_num | order_item | prod_id | quantity | item_price | +-----------+------------+---------+----------+------------+ | 20005 | 1 | BR01 | 100 | 5.49 | | 20005 | 2 | BR03 | 100 | 10.99 | | 20006 | 1 | BR01 | 20 | 5.99 | | 20006 | 2 | BR02 | 10 | 8.99 | | 20006 | 3 | BR03 | 10 | 11.99 | | 20007 | 1 | BR03 | 50 | 11.49 | | 20007 | 2 | BNBG01 | 100 | 2.99 | | 20007 | 3 | BNBG02 | 100 | 2.99 | | 20007 | 4 | BNBG03 | 100 | 2.99 | | 20007 | 5 | RGAN01 | 50 | 4.49 | | 20008 | 1 | RGAN01 | 5 | 4.99 | | 20008 | 2 | BR03 | 5 | 11.99 | | 20008 | 3 | BNBG01 | 10 | 3.49 | | 20008 | 4 | BNBG02 | 10 | 3.49 | | 20008 | 5 | BNBG03 | 10 | 3.49 | | 20009 | 1 | BNBG01 | 250 | 2.49 | | 20009 | 2 | BNBG02 | 250 | 2.49 | | 20009 | 3 | BNBG03 | 250 | 2.49 | +-----------+------------+---------+----------+------------+

Orders 表

mysql> SELECT * FROM orders; +-----------+---------------------+------------+ | order_num | order_date | cust_id | +-----------+---------------------+------------+ | 20005 | 2012-05-01 00:00:00 | 1000000001 | | 20006 | 2012-01-12 00:00:00 | 1000000003 | | 20007 | 2012-01-30 00:00:00 | 1000000004 | | 20008 | 2012-02-03 00:00:00 | 1000000005 | | 20009 | 2012-02-08 00:00:00 | 1000000001 | +-----------+---------------------+------------+

Products 表

mysql> SELECT * FROM products; +---------+---------+---------------------+------------+ | prod_id | vend_id | prod_name | prod_price | +---------+---------+---------------------+------------+ | BNBG01 | DLL01 | Fish bean bag toy | 3.49 | | BNBG02 | DLL01 | Bird bean bag toy | 3.49 | | BNBG03 | DLL01 | Rabbit bean bag toy | 3.49 | | BR01 | BRS01 | 8 inch teddy bear | 5.99 | | BR02 | BRS01 | 12 inch teddy bear | 8.99 | | BR03 | BRS01 | 18 inch teddy bear | 11.99 | | RGAN01 | DLL01 | Raggedy Ann | 4.99 | | RYL01 | FNG01 | King doll | 9.49 | | RYL02 | FNG01 | Queen doll | 9.49 | +---------+---------+---------------------+------------+ -----------------------------------------------------------------------+ prod_desc | -----------------------------------------------------------------------+ Fish bean bag toy, complete with bean bag worms with which to feed it | Bird bean bag toy, eggs are not included | Rabbit bean bag toy, comes with bean bag carrots | 8 inch teddy bear, comes with cap and jacket | 12 inch teddy bear, comes with cap and jacket | 18 inch teddy bear, comes with cap and jacket | 18 inch Raggedy Ann doll | 12 inch king doll with royal garments and crown | 12 inch queen doll with royal garments and crown | -----------------------------------------------------------------------+

Vendors 表

mysql> SELECT * FROM vendors; +---------+-----------------+-----------------+------------+------------+----------+--------------+ | vend_id | vend_name | vend_address | vend_city | vend_state | vend_zip | vend_country | +---------+-----------------+-----------------+------------+------------+----------+--------------+ | BRE02 | Bear Emporium | 500 Park Street | Anytown | OH | 44333 | USA | | BRS01 | Bears R Us | 123 Main Street | Bear Town | MI | 44444 | USA | | DLL01 | Doll House Inc. | 555 High Street | Dollsville | CA | 99999 | USA | | FNG01 | Fun and Games | 42 Galaxy Road | London | NULL | N16 6PS | England | | FRB01 | Furball Inc. | 1000 5th Avenue | New York | NY | 11111 | USA | | JTS01 | Jouets et ours | 1 Rue Amusement | Paris | NULL | 45678 | France | +---------+-----------------+-----------------+------------+------------+----------+--------------+

這就是本文所有的內容了，如果感覺還不錯的話。

? 點個贊再走吧！！！?

后續會繼續分享《Mysql從入門到入魔》系列文章，如果感興趣的話可以點個關注不迷路哦~。

MySQL SQL

版權聲明：本文內容由網絡用戶投稿，版權歸原作者所有，本站不擁有其著作權，亦不承擔相應法律責任。如果您發現本站中有涉嫌抄襲或描述失實的內容，請聯系我們jiasou666@gmail.com 處理，核實后本網站將在24小時內刪除侵權內容。