American River College American University Amherst College ...... ......
id name type created_at updated_at
I want to import text field values in
name column and want to assign some default value to other fields like "college" to
type field, current date time to
created_at and NULL to
What changes i would need to make in the following command
LOAD DATA LOCAL INFILE '/var/www/colleges.txt' INTO TABLE selections ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
I have seen various examples of stackoverflow.com but could not find matching with my specific requirement.