List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:July 26 2002 3:06pm
Subject:Re: Fw: Complex SQL assistance
View as plain text  
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 run JUST SQL.
What are you using?

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. If the record doesn't exist then insert it.
>
>For reasons too complex to go into at this stage using anything except SQL
>is not possible.
>
>Any and all suggestions welcome.
>
>-Corey
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread115636@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
Fw: Complex SQL assistanceCorey Wallis26 Jul
  • Re: Fw: Complex SQL assistanceDaniel Koch26 Jul
  • Re: Fw: Complex SQL assistanceGerald Clark26 Jul
    • RE: Fw: Complex SQL assistanceJon Frisby27 Jul
      • Re: Fw: Complex SQL assistanceCorey Wallis30 Jul
  • Re: Fw: Complex SQL assistanceDiana Soares26 Jul
  • RE: Complex SQL assistanceAlain Fontaine26 Jul