>Now, I have another problem:
>ERROR 13 (HY000): Can't get stat of
'/users/lolajl/documents/development/knitlib/datafiles/standardwttype.txt'
>(Errcode: 13)
That's permission. is the dir 755?
PB
Lola J. Lee Beno wrote:
Peter Brawley wrote:
>ERROR 1064 (42000): You have an error in your S
Lola J. Lee Beno wrote:
ERROR 13 (HY000): Can't get stat of
'/users/lolajl/documents/development/knitlib/datafiles/standardwttype.txt'
(Errcode: 13)
Never mind . . . I figured that I needed to add LOCAL to the query.
Should have gone back to the manual page for LOAD DATA.
--
Lola - mai
Peter Brawley wrote:
>ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your >MySQL server version for the right
syntax to use near 'standardwttype.txt`
Use single quotes not (dreaded) backticks.
This seems to have fixed one problem. Now, I ha
Lola
>I keep getting an error message:
>ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your >MySQL server version for the right
syntax to use near 'standardwttype.txt`
Use single quotes not (dreaded) backticks.
PB
-
Lola J. Lee Beno wrot
I'm trying to import a set of data into a database (MySQL 5.0.17-max).
Here's the query that I tried to run:
LOAD DATA INFILE `standardwttype.txt`
INTO TABLE StandardWeightType
FIELDS TERMINATED BY `\t`
LINES TERMINATED BY `\r`
(standard_wt_type_id, standard_wt_desc, standard_wt_lud);
And here'