If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

mySql issue

ChicoMendez · 2004-02-06 07:13:46

Hi im trying to load data into a table in sql from a csv file using the phpmyAdmin SQL -> Insert data from a textfile into table function Hopwever im getting this message: Im using the lateast version of mysql also which should allow this command. any ideas?

Options

06-02-2004 8:13am

#1

ChicoMendez

Registered Users Posts: 648 ✭✭✭

Join Date: July 2003

Posts: 364

Hi
im trying to load data into a table in sql from a csv file using the phpmyAdmin SQL -> Insert data from a textfile into table function

Hopwever im getting this message:

MySQL said:

#1148 - The used command is not allowed with this MySQL version

Im using the lateast version of mysql also which should allow this command.

any ideas?

0

Comments

Options
#2 06-02-2004 10:25am
mneylon

Registered Users Posts: 7,739 ✭✭✭

Join Date: April 2001

Posts: 7231

Check the syntax etc., very carefully. MySQL will moan if the syntax isn't the way it wants it.

Blog | Tweets

0
Options
#3 11-02-2004 6:46pm
ChicoMendez

Registered Users Posts: 648 ✭✭✭

Join Date: July 2003

Posts: 364

indeed syntax issues it as

0