本人在自學SQL，手邊有本《SQL必知必會》（第四版），書中2.2 檢索單個列 中有如下陳述句
SELECT prod_name
FROM Products；
接著就會顯示輸出結果。
我按照這個流程在自己的電腦上操作時，提示 no database selected，是不是因為沒有匯入相應的Products表？我從這本書的附錄中找到下載地址，下載到的檔案中有 populate.txt,查了下看里面有相應的”Populate Products table“內容，但請問這段內容怎么才能匯入到資料庫中供我后續練習查詢使用？
初學入門，請多多指教，先謝謝了!
下載的腳本中有關”Populate Products table“這一段具體內容如下：
INSERT INTO Products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('BR01', 'BRS01', '8 inch teddy bear', 5.99, '8 inch teddy bear, comes with cap and jacket');
INSERT INTO Products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('BR02', 'BRS01', '12 inch teddy bear', 8.99, '12 inch teddy bear, comes with cap and jacket');
INSERT INTO Products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('BR03', 'BRS01', '18 inch teddy bear', 11.99, '18 inch teddy bear, comes with cap and jacket');
INSERT INTO Products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('BNBG01', 'DLL01', 'Fish bean bag toy', 3.49, 'Fish bean bag toy, complete with bean bag worms with which to feed it');
INSERT INTO Products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('BNBG02', 'DLL01', 'Bird bean bag toy', 3.49, 'Bird bean bag toy, eggs are not included');
INSERT INTO Products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('BNBG03', 'DLL01', 'Rabbit bean bag toy', 3.49, 'Rabbit bean bag toy, comes with bean bag carrots');
INSERT INTO Products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('RGAN01', 'DLL01', 'Raggedy Ann', 4.99, '18 inch Raggedy Ann doll');
INSERT INTO Products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('RYL01', 'FNG01', 'King doll', 9.49, '12 inch king doll with royal garments and crown');
INSERT INTO Products(prod_id, vend_id, prod_name, prod_price, prod_desc)
VALUES('RYL02', 'FNG01', 'Queen doll', 9.49, '12 inch queen doll with royal garments and crown');
uj5u.com熱心網友回復：
問題已解決，很有成就感，就是先創建自己的一個資料庫，在按照附件中的“CREATE.TXT”中的代碼創建一個新TABLE，然后再通過“Populate.txt”來插入資料就行啦！uj5u.com熱心網友回復：
要先USE DATABASE轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/90971.html
標籤：MySQL
上一篇：R中安裝baidumap包時遇到ERROR: lazy loading failed for package 'baidumap'
下一篇：跪求指教，mysql短期掛起