Hello,
I'm a very new mysql/php user and am trying to use the load data infile
command without luck. I'd like to replace a table using a text file but
can't get it to work. I set up a test table with no records using a telnet
console. I'm trying to write a php page that takes the file on the se
.. Thanks again!!
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 1:55 PM
To: [EMAIL PROTECTED]
Cc: Montagna, Dan
Subject: RE: Load data infile issue
On 5 Aug 2003 at 11:16, "Montagna,Dan" <[EMAIL PROTECTED]> wrote:
> Thanks
ot; the load local file option?
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 10:53 AM
To: '[EMAIL PROTECTED]'
Cc: Montagna, Dan
Subject: Re: Load data infile issue
On 5 Aug 2003 at 9:37, Montagna, Dan wrote:
> $result = mysql_db_
I'm using some default table names and such here...my actual code has the
appropriate table, server, un, pw etc...
On 5 Aug 2003 at 11:16, "Montagna,Dan" <[EMAIL PROTECTED]> wrote:
> Thanks Keith, that got me past the first two queries but I'm now
> getting an " Invalid DATA LOAD query" . Someone told me that the
> "load data infile option is not always on by default. Is there a
> piece of code I need to in
On 5 Aug 2003 at 9:37, Montagna, Dan wrote:
> $result = mysql_db_query('$sql_id',"DELETE FROM tablename") or die
> ("Invalid DELETE query");
It's helpful to print mysql_error() when you have an error, so you
get a message more specific than "Invalid DELETE query". In this
case, you're trying t
