Jon,
This is exactly what was needed. You are correct in that we're using the
mysql
To: "Gerald Clark" <[EMAIL PROTECTED]>; "Corey Wallis"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, July 27, 2002 8:16 AM
Subject: RE: Fw: Complex S
Peoples,
I'm currently trying to work out if this is possible by SQL. I have the need
to use SQL and only SQL to achieve the following.
If a record exists and meets a certain criteria (i.e. field X = '1234') then
update the record. If the record doesn't exist then insert it.
For reasons too com
Take a look at REPLACE:
http://www.mysql.com/doc/R/E/REPLACE.html
On Fri, 2002-07-26 at 10:17, Corey Wallis wrote:
> Peoples,
>
> I'm currently trying to work out if this is possible by SQL. I have the need
> to use SQL and only SQL to achieve the following.
>
> If a record exists and meets a c
> SQL does not exist in a vacuum.
> You have to run a client.
> The client is part of or runs under some scripting language ( perl ,
> php, sh, command.com )
> which in turn runs on an operating system.
> You have to somehow pass values that you want to select, update,
> or insert.
> So it really
SQL does not exist in a vacuum.
You have to run a client.
The client is part of or runs under some scripting language ( perl ,
php, sh, command.com )
which in turn runs on an operating system.
You have to somehow pass values that you want to select, update, or insert.
So it really not possible to
On Fri, 2002-07-26 at 05:17, Corey Wallis wrote:
> Peoples,
>
> I'm currently trying to work out if this is possible by SQL. I have the need
> to use SQL and only SQL to achieve the following.
>
> If a record exists and meets a certain criteria (i.e. field X = '1234') then
> update the record.
