Running MySQL 4.0.12-NT on a Windows 2k Pro Server.
When I attempt to execute mysqldump.exe, I get the following error:
mysqldump: ERROR: unknown variable 'local-infile=1'
I tried using --force and it didn't help.
Showing the variables, I get local-infile to be TRUE. I looked in my.ini
and found
At 11:36 AM 10/13/2004, Paul DuBois wrote:
At 11:10 -0400 10/13/04, Michael Ragsdale wrote:
I've been using mysql_insert_id() with great success, but now I've got a
problem. I'm using UPDATE to, well, update a record in a database and
according to the docs...
mysql_insert_id() i
I've been using mysql_insert_id() with great success, but now I've got a
problem. I'm using UPDATE to, well, update a record in a database and
according to the docs...
mysql_insert_id() is updated after INSERT and UPDATE statements that
generate an AUTO_INCREMENT value or that set a column val
Shawn, thank you - that did the trick.
-Mike
At 10:18 AM 6/2/2004, [EMAIL PROTECTED] wrote:
Have you tried using the IN operator?
SELECT denewbs, dewrbtr, dekostl, desgtxt, deprojk,
degeber, de_heid, acdesc, acfund
FROM (details INNER JOIN headers ON details.de_heid = headers.heid)
LEFT JOI
I have some code that's been in production for a few years and now is
presenting a problem. The following is on a mysql 3.23.38 server:
SELECT b.denewbs, b.dewrbtr, b.dekostl, b.desgtxt, b.deprojk,
b.degeber, b.de_heid, c.acdesdc, c.acfund
FROM headers a, details b, acctref c
WHERE a.he_b
for it and
it is gone. I can't seem to find in the manual how to recreate this file
and exactly what the contents are to be. Where can I find the specifics on
this file and is it truly the cause of my problems?
******
* M
