Load Data CSV into MySQL

Photo by Alejandro Escamilla on Unsplash

For this blog, I will import a CSV file to a MySQL server(using MAMP) to create a practice platform for SQL statements. More specifically, I will import the titanic dataset(train.csv), which I can find here (https://www.kaggle.com/c/titanic). This tutorial will be broken down into three steps:

  1. Installing MAMP
    Installing and editing configuration parameters
  2. Creating Database & Table
    Creating…