Re: Load Data Infile Without Inserting New Rows

2003-06-10 Thread gerald_clark
You will have to write a program to read your text files and insert/update the appropriate records. Fernando Gerent wrote: Hi everybody, I need to use the Load Data Infile to insert different columns from different files in a table, but I can't figure out how to keep the number of rows, like f

Load Data Infile Without Inserting New Rows

2003-06-10 Thread Fernando Gerent
Hi everybody, I need to use the Load Data Infile to insert different columns from different files in a table, but I can't figure out how to keep the number of rows, like for example, if I have a table for people's names, ages and phone numbers, and each of these information is in a different txt