MySQL Forums
Forum List  »  MySQL Workbench

How to paste info from ready txt tables to Mysql ?
Posted by: Kobu Dze
Date: December 19, 2017 05:40AM

I study MYsql from Ben Forta's book SQL in 10 minutes(published in 2014).
I have on my laptop last version of the Mysql, as I understand it is installed correctly.
In the book of Forta are two ready txt format tables which are supposed to copy and then paste in the Mysql.
I do not understand how to do that.
Could you help me, please?

In the book is written how to do that, but I do not understand:

11. Double-click on the database to open the SQL Editor
12. To create a new database (called a Schema in MySQL and MariaDB) click on the Create New
Schema button (it is the one that looks like a yellow barrel with a + sign next to it), this will
display a dialog box.
13. Set name to tysql, you can leave all the other fields blank and click Apply. You’ll be prompted for
verification and click Apply again to create the database
14. You can now type SQL in the editor window, but you must first make sure that your newly
created database is selected. If it is selected its name will be in bold and the name will be
displayed in the title bar. If something other than tysql is selected, double-click on tysql in the
Object Browser
15. Copy and paste contents of Create (may see warnings about keys, ok)
16. Execute Query button (yellow lightning bolt) to execute
17. Copy and paste contents if Populate
18. Test it with SELECT * FROM Customers;

Options: ReplyQuote

Written By
How to paste info from ready txt tables to Mysql ?
December 19, 2017 05:40AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.