Can you please review and provide suggestions if needed for my syntax to load data into a MySQL table without overwriting the data? Please see my script below which I would run under mysql in command line....
load data local infile 'tbl_name.txt'
append into table TBL_NAME
fields terminated by ':;:';
optimize table TBL_NAME;