PHP DB - Re: [PHP-DB] Re: SQL Insert INTO question

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: [PHP-DB] Re: SQL Insert INTO question

David Mitchell

2005-12-08, 6:59 pm

Is that a syntax supported by MySQL? That is, an INSERT with WHERE clause?
I tried it against Oracle, and it doesn't work (can you imagine how
upsetting it would have been to have learned that, after having worked with
SQL for several years, one can do an update using an INSERT statement?).
I'm pretty sure it doesn't work against MS SQL Server, DB2, etc (not 100%
certain, but 99.9%).

On 12/8/05, El Bekko <elbekko@gmail.com> wrote:
>
> g

girl1 wrote:
>
> "INSERT INTO reviews (review_txt)
> VALUES
> ('$_POST['review']') WHERE review_id = '$id'";
>
> There, now it should work :)
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

Sponsored Links