Dear Friends, My data in text file isn't been loaded to columns in table. Data text file is in data directory of server.
rest of the commands are as follows, any guidance, please. mysql> load data -> infile 'kemailsusa.txt' -> into table -> kemailsusa; ERROR 1062: Duplicate entry '0-' for key 1