Time for action – loading a table with a list of manufacturers
Let's suppose that you love jigsaw puzzles and decided to open a store for selling all kinds of them. You have made all the arrangements and the only missing thing is the software. You have already acquired software to handle your business but you still have a hard task of adding data into the database, that is, loading the basic information about the products you are about to sell in the database.
As this is the first of several tutorials in which you will interact with this database, the first task you have to do is to create the database.
Note
For MySQL-specific tasks—for example, the creation of a database—we will use SQuirreL SQL Client . If you use this tool, make sure you have added a driver for MySQL. For assistance, you can follow this link http://squirrel-sql.sourceforge.net/user-manual/quick_start.html. Alternatively, you can do this task using the MySQL Command Line Client or any other GUI tool.
Download the
js.sql...
