Reading table data from a MySQL database
Data can be stored in database tables also. This recipe demonstrates how we can read data from a table in MySQL.
In order to perform this recipe, we will require the following:
- Download and install MySQL community server from http://dev.mysql.com/downloads/mysql/. The version used in this recipe is 5.7.15.
- Create a database named
data_science. In this database, create a table named
booksthat contains data as follows:
The choice of the field types does not matter for this recipe, but the names of the fields need to exactly match those from the exhibit shown here.
- Download the platform independent ...