MySQL – Using “Load Data” Statement

Background Let us load data into our MySQL using it's native "Load Data" statement. Outline Data Source Identify Data Source Review Data Download Data Tools CURL Prepare Target Storage Create Tables Create Staging Table Create Actual Table Load Data Load data into staging table Move data from staging table into actual table Tasks Data Source … Continue reading MySQL – Using “Load Data” Statement

MySQL:- Date Types & Sizes

Background Playing around more with MySQL and wanted to see why a certain implementation specification was chosen over another. I really struggled to make sense of things. Date Types & Sizes There are a couple of types that one can use for date & time in MySQL. Inclusive:- time date datetime timestamp Code Output