I'm trying to load a .txt file into MySQL.

Here is what I'm typing LOAD DATA LOCAL INFILE 'scanner1.txt' INTO TABLE charleston FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'; and the first column which should be auto_increment isn't counting up by 1 for the row id. Second and third columns just have NULL in them. It doesn't list the scanner licensee or frequency.

Here is how the text file is formatted. What would be the command that I should use to load data in MySQL its a .txt file and the text file is formatted like this??

30.8000 Professional Licensing Consultants, Inc.
30.8400 HARDEES REST HD813B; HM ********CIS INC
31.1600 DINO CONTRACTORS INC

There is only a tab that seperates the frequency from the licensee.

Am I typing the wrong MySQL command or do I need to go into the text file and enter code to it or what? Basically what is the easiest way to do this?