Some usual/unusual queries for mySql

querires.sql

-- Load Data from a text file with comma separated columns
LOAD DATA LOCAL INFILE '/path/to/file.txt' INTO TABLE `tableName`

FIELDS TERMINATED BY 'x' 
-- (here x could be comma ',', tab '\t', semicolon ';', space ' ')

LINES TERMINATED BY 'y';
-- (here y is a new line character, it can be ¬, \n or anything) sometimes you may need to use only fields teminated by 
----------------------------------------------------------------