Re: import data from text files

2004-01-09 Thread Nestor Florez
Armin, 1)When you say that the records are duplicate, do you mean the record number(first field) or or do you mean the entire record is a duplicate? 2)Now to load a file made out of comma separated fields into a table that was created in the same field format, here are 2 ways: a)mysql> USE

Re: import data from text files

2004-01-09 Thread Roger Baklund
* Armin > I've got two problem with mysql , maybe it is not a real > 'problem' but i need help hardly ! :) > > 1 > in a table , we got many record ( 1400 ) , some of them are > equal , i want to delete just one of them , in other word , i don't > want two record equal . Take a look at SELECT