Taylor,
Thursday, May 23, 2002, 11:46:16 PM, you wrote:
TL What priviledge does a user need in order to be able to execute the load data
infile command in mysql..? is it FILE?
Yes, you are right. Your user must have file privilege.
Note: MySQL must have permissions on that file in your OS.
Yes it is ...
See: http://www.mysql.com/doc/P/r/Privileges_provided.html
Gurhan
-Original Message-
From: Taylor Lewick [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 4:46 PM
To: [EMAIL PROTECTED]
Subject: mysql load data question
What priviledge does a user need in order to
Everytime you have something to ask, first point your browser to :
http://www.mysql.com/doc/
Type in the keywords (in this case LOAD DATA)
The first url in the resultset will be :
http://www.mysql.com/doc/L/O/LOAD_DATA.html
which is what you are looking for.
Gurhan
-Original Message-
Hi,
Look at http://www.mysql.com/doc/L/O/LOAD_DATA.html
and you can try this...
load data infile 'yourfile' into table your_table fields terminated by
'\your_separator_char_for_fields' lines terminated by
'\your_separator_char_for_row';
Regards,
Gelu