Sean,
Monday, October 07, 2002, 10:11:51 PM, you wrote:
SM> I seem to have run into a rather peculiar problem. I was attempting to load
SM> data into a table from a file. I checked with the online documentation and
SM> found the following syntax:
SM> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;
SM> I used this format exactly (with my own file and table names of course) and
SM> was greeted with the following error message:
SM> ERROR 1148: The used command is not allowed with this MySQL version
SM> Calling 'mysql --version' I have found that I am using version 11.18 Distrib
SM> 3.23.52 (on w2k). Is there another means by which I can get large amounts
SM> of data into my table without using a whole whack of INSERT statements?
You can specify local-infile=1 for MySQL server and client:
http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
