Rianna
09-23-2006, 12:46 AM
Hello, this is my first attempt at loading a table and having trouble.
Mysql is on my server, version 4.0.24 the database name is "mylinks"
So I made a text file named "mylinks" and loaded this into it. The test items are 3 fields that go into the 3 different columns in the table. What am I doing wrong? Thanks you very much!
mysql> LOAD DATA LOCAL INFILE '/path/mylinks.txt' INTO TABLE mylinks;
test1 test2 test3
Mysql is on my server, version 4.0.24 the database name is "mylinks"
So I made a text file named "mylinks" and loaded this into it. The test items are 3 fields that go into the 3 different columns in the table. What am I doing wrong? Thanks you very much!
mysql> LOAD DATA LOCAL INFILE '/path/mylinks.txt' INTO TABLE mylinks;
test1 test2 test3