[~/examples_mysql/my_business]$ more *sql

::::::::::::::
create_Cust_id.sql
::::::::::::::
# Create Cust table

USE u30;
DROP TABLE IF EXISTS Cust;
CREATE TABLE Cust
(
        last_name VARCHAR(15) NOT NULL,
        first_name VARCHAR(15) NOT NULL,
        phone VARCHAR(12) NULL,
        email VARCHAR(20) NULL,
        customer_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
);

::::::::::::::
create_Cust.sql
::::::::::::::
# Create Cust table

USE u30;
DROP TABLE IF EXISTS Cust;
CREATE TABLE Cust
(
        last_name VARCHAR(15) NOT NULL,
        first_name VARCHAR(15) NOT NULL,
        phone VARCHAR(12) NULL,
        email VARCHAR(20) NULL
);

::::::::::::::
insert_Cust.sql
::::::::::::::
INSERT INTO Cust VALUES ('Lingras','Pawan','420-5798','pawan@cs.smu.ca');
INSERT INTO Cust VALUES ('Scobey','Porter','420-5790','porter@cs.smu.ca');

::::::::::::::
load_Cust_comma.sql
::::::::::::::
LOAD DATA LOCAL INFILE "Cust.csv" INTO TABLE Cust FIELDS TERMINATED BY ',';

::::::::::::::
load_Cust_id_comma.sql
::::::::::::::
LOAD DATA LOCAL INFILE "Cust.csv" INTO TABLE Cust FIELDS TERMINATED BY ',';

::::::::::::::
load_Cust_id_tab.sql
::::::::::::::
LOAD DATA LOCAL INFILE "Cust.tsv" INTO TABLE Cust;

::::::::::::::
load_Cust_tab.sql
::::::::::::::
LOAD DATA LOCAL INFILE "Cust.tsv" INTO TABLE Cust;

[~/examples_mysql/my_business]$