bjoerndalen
08-28-2003, 07:11 PM
I've just started trying to get to grips with MySQl etc.
I've managed to create a database and add a table. I have managed to populate it using the INSERT INTO and VALUES commands.
I also understand that you can do this by creating a text file.I have tried this and used the following command.
LOAD DATA LOCAL INFILE "filename.txt" INTO TABLE Tablename;
When I do this I get the following message.
Error 1148: The used command is not allowed with this MySQL version.
I am using version 3.23.49 I am using the downloaded manual from MySQL site and a book which I got that version from. The book uses it as an example so I was wondering why it doesnt work. If anybody can help I will be grateful.
Not sure if this is the right place for this thread?
Dave :)
I've managed to create a database and add a table. I have managed to populate it using the INSERT INTO and VALUES commands.
I also understand that you can do this by creating a text file.I have tried this and used the following command.
LOAD DATA LOCAL INFILE "filename.txt" INTO TABLE Tablename;
When I do this I get the following message.
Error 1148: The used command is not allowed with this MySQL version.
I am using version 3.23.49 I am using the downloaded manual from MySQL site and a book which I got that version from. The book uses it as an example so I was wondering why it doesnt work. If anybody can help I will be grateful.
Not sure if this is the right place for this thread?
Dave :)