cassie5643
asked on
Script to append data into MySQL tables
Hello,
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....
--TBL_NAME
load data local infile 'tbl_name.txt'
append into table TBL_NAME
fields terminated by ':;:';
optimize table TBL_NAME;
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....
--TBL_NAME
load data local infile 'tbl_name.txt'
append into table TBL_NAME
fields terminated by ':;:';
optimize table TBL_NAME;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.