I am working through the tutorial that is included with the mysql install. I am inserting data from a text file into a table called pets in a database called test. The sql "describe" command shows the table is set up properly. I made a text file that is has a row per record and the fields are separated by tabs. I saved it in my documents folder under the name pets.txt . The directions tell me to use the following command:
mysql> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet; When I do this I get an error!!!
mysql> load data local infile "/users/bbrown/documents/pet.txt" into table pet;
ERROR 1148: The used command is not allowed with this MySQL version
What does this mean?? I'm using version 3.23.49 of mysql.
Are you supposed to use the path to the text file in this command? If not where should it be saved? Any hints are welcomed!!!
Thanks.....
Top
