Re: [PHPLIB-DEV] cvs commit From: Adam N. Thompson, MCNE, MCSE (athompso <email protected>)
Date: 01/24/00

Kristian Köhntopp wrote:

> > Firstly, the MySQL docs do not describe a REPLACE...WHERE syntax.
>
> Please check out
> http://www.mysql.com/Manual_chapter/manual_Reference.html#REPLACE

Based on what I see in the manual, the valid syntaxes are:
 1. REPLACE ... VALUES ...
 2. REPLACE ... SELECT ...
 3. REPLACE ... SET ...

It would be perfectly acceptable to tack on a WHERE clause to syntax #2, but it applies to the SELECT not the REPLACE.

If you've actually managed to execute a REPLACE WHERE statement, please let me know - so I can disregard the documentation. Please also let
me know what version of MySQL you're using, as I have just this instant tried it and received a syntax error.

-Adam 

--
-Adam Thompson, MCNE, MCSE, CWT, A+
 Vice-President / Chief Technology Officer
 Commerce Design Inc.
 athompso <email protected>
 tel: (204) 942-1648
 fax: (204) 989-8080

- PHPLIB Developers Mailing List. Send messages to <phplib-dev <email protected>>. To unsubscribe, send "unsubscribe" to <phplib-dev-request <email protected>> in the body, not the subject, of your message.