PgPEvgTs

1CREATE DATABASE moovydb;
2USE moovydb;
3
4GRANT ALL ON moovydb.* TO moovydbuser@localhost IDENTIFIED BY 'YOUR_COMPLICATED_DIFFICULT_TO_REMEMBER_PASSWORD_GOES_HERE';
5
6CREATE TABLE IF NOT EXISTS moviestable (
7    year int(4) NOT NULL,
8    month varchar(3) NOT NULL,
9    day int(2) NOT NULL,
10    movietitle varchar(250) DEFAULT NULL,
11    director varchar(20) DEFAULT NULL,
12    actor varchar(20) DEFAULT NULL,
13    music varchar(20) DEFAULT NULL,
14    PRIMARY KEY(movietitle)
15    );
16
17LOAD DATA LOCAL INFILE '/tmp/2005' INTO TABLE moviestable
18FIELDS TERMINATED BY '|' 
19ENCLOSED BY '' 
20LINES TERMINATED BY '\n';