Link to home
Start Free TrialLog in
Avatar of cassie5643
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;
ASKER CERTIFIED SOLUTION
Avatar of mwiercin
mwiercin

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial