Dear all I had a source file which containing rate figures, what i want to do is to insert these rate to a specific field of an existing table using "Load Data Infile" query!
here is the example existing table data: A B C 01 AUD #rate 02 HKD #rate 03 JPY #rate 04 USD #rate When i import the csv file, it will only replace the field C without changing any values on field A & B. Please help me with this, it is urgent!! Thx a lot Jack [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php