Unit 17Setting Up a MySQL Database

A relational database is a collection of permanently stored and possibly sorted and indexed tables. Relational databases are excellent for storing tabular data (such as data found in CSV files), where one table represents a variable type, the columns of the table represent variables, and the rows represent observations, or records.

You don’t need Python to operate a database; however, you must know Structured Query Language (SQL) or its specific implementation, such as MySQL, to access a relational database either from its command line or from a Python application.

To interact with a running MySQL database server from the command line, you need a MySQL client, such as mysql. All MySQL commands are case-insensitive ...

Get Data Science Essentials in Python now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.