We'll go through a couple of different ways to create a database table in this section. We will use MySQL Workbench for both methods, but one method will not require scriptwriting and the other one will.
First, let's download and analyze the data that will be used for creating the tables:
- Download the CSV files from https://github.com/PacktPublishing/learn-sql-database-programming/tree/master/baseballdatabank-csv/csv-files. The files we will be using in this section are in the baseballdatabank-csv/csv-files folder. You will set up just a couple of small tables from this data so that you can have an idea of how the data integrity and keys will work on tables.
- Working with the Managers.csv file, the columns ...