RE: [PHP] Re: How to UPDATE two MySQL Tables
| From: | John Holmes | Date: | Sat, 27 Jul 2002 15:24:38 +0000 |
| Subject: | RE: [PHP] Re: How to UPDATE two MySQL Tables | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-109973@lists.php.net to get a copy of this message | ||
> You can use REPLACE instead of making two separate queries (UPDATE and
> INSERT) because it checks if it is there, and if it's not, then it
adds
> it;
> otherwise it updates it. I think that's right ... but the SQL
server's
> SQL
> server is broken! (the irony!)
Just note that REPLACE is MySQL specific. A solution using it may not be
portable to other databases. May or may not matter to you...
---John Holmes...