Dear List, Is it possible to load data, for example with 2 columns in a table and add the value of the third column using a command?
Example: I have these data, stored in two text files: a)species_1 1820 20 1850 20 1825 10 b)species_2 4000 30 5000 20 and I would like to create this table: sample counts species 1820 20 species_1 1850 20 species_1 1825 10 species_1 4000 30 species_2 5000 20 species_2 Is it possible to fill this table with LOAD DATA and add the content of the species-column using a command, without editing of the files? Thanks, Jan ___________________________________________ Dr. Jan Bartholdy University of Bonn Institute of Paleontology Nussallee 8 53115 Bonn Germany phone +49 0228 733336 fax +49 3301 808130 cellphone +49 172 3945713 email [EMAIL PROTECTED] + ____________ Virus checked by G DATA AntiVirusKit Version: AVK 15.0.2975 from 09.02.2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
