Forum Moderators: coopster

Message Too Old, No Replies

Insert data from a textfile into a table

textfile to table

         

tenerifetrekn

1:28 pm on May 10, 2005 (gmt 0)



Hello...I am new (very evident)
Using PHPAdmin how do I insert a textfile into a table without getting errors? Any help appreciated. This is the error I receive:

Error

SQL-query :

LOAD DATA LOCAL INFILE '' INTO TABLE `SCcodigos` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'

MySQL said:

File '' not found (Errcode: 2)
Back

kazecoder

3:13 pm on May 10, 2005 (gmt 0)

10+ Year Member



Try using the built-in import function. It can be funny sometimes.

jatar_k

4:22 pm on May 10, 2005 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



Welcome to WebmasterWorld tenerifetrekn,

you are missing the filename in your command