[thelist] LOAD DATA MYSQL

[Warden, Matt]

> I have a table with only one field it and I want to load a lot of data
into
> that one field.  I am using phpadmin(which has beena godsend) and am using
> the following syntax.:
> LOAD DATA INFILE 'categories.sql' INTO TABLE all_cats;
>
> it tells me that access is denied which I dont understand because Im
already
> connected to my db?

Do you have access to categories.sql? Check permissions. The file is on the
server, isn't it?

> If I was to make a txt file with the info in it that I want to insert into
> the field how would I go about it.  I can create tables that way but this
> has stumped me for the present.

you can create a text file with a batch set of SQL, but it's easier to do
the load.

--
mattwarden
mattwarden.com