Loading Data into table question?
I'm in the process of working through the MySQL Tutorial http://dev.mysql.com/doc/mysql/en/Tutorial.html.
I'm at the step of attempting to load data in the table:http://dev.mysql.com/doc/mysql/en/Loading_tables.html
I've intially inputed the example data in an excel worksheet and saved the file as .txt file.
The file saves with the required "tab" between each row of data.
When I use terminal command:LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet;
only the first row of data is loaded into the table? I've also tried to load the .txt file via phpmyadmin and have had no luck correctly adding the data. When I try this approach, again only the first row is added, but the first three rows of the .txt file are added to FIRST row of the mysql table.
I want to be able to organise data for input into MySQL data bases. Is there a better program than excel to store and organise data for later input into MySQL data bases?
I'm using a G4 PowerBook with OSX 3.7.