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.
What priviledge does a user need in order to be able to execute the load data infile
command in mysql..? is it FILE?
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
Help Wanted. Seeking Telepath...
You Know where to apply.
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
I read in the Mysql manual where you can change the default column seperator, but it
didnt specify how to do this.
So, how can I tell the LOAD DATA command to use commas, or better yet, where can I go
to find out about mysql command syntax...?
Thanks,.
Taylor Lewick
Unix System
-
From: Taylor Lewick [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 4:52 PM
To: [EMAIL PROTECTED]
Subject: Mysql Load Data question
I read in the Mysql manual where you can change the default column
seperator, but it didnt specify how to do this.
So, how can I tell the LOAD DATA command
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Taylor Lewick [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 16, 2002 11:52 PM
Subject: Mysql Load Data