RE: [PHP-DB] update and join?
| From: | John W. Holmes | Date: | Thu, 10 Oct 2002 23:15:34 +0000 |
| Subject: | RE: [PHP-DB] update and join? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22329@lists.php.net to get a copy of this message | ||
> Quick question....is it possible to do an update query w/ a join yet?
If
> not, what is your preferred method? Would you take care of it on the
PHP
> side?
Probably depends on your database, but MySQL doesn't support it. I think
MySQL 4.0 might.
> I need to update a table w/ data from another table if certain
conditions
> are true, i.e the fields in the table to be joined are "NULL"....
You'll have to use a scripting language, or something outside of the
database. Or maybe a INSERT INTO ... SELECT ... will help?
---John Holmes...