Updating Across Tables
| From: | Stephen Hui | Date: | Fri, 03 Nov 2000 20:23:20 +0000 |
| Subject: | Updating Across Tables | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-4200@lists.php.net to get a copy of this message | ||
Hi, everyone.
I have a database with two tables and I need to update a column in the
first column by cross-referencing it with a column in the second table.
Is there a way I can do this in MySQL? I read that some systems have a
FROM clause in the UPDATE statement, but as far as I can tell, MySQL
does not have this feature.
Thanks,
Stephen.
--
Stephen Hui, ARL:UT, Austin, Texas
Computer Terms: Programmer - A red-eyed, mumbling mammal
capable of conversing with inanimate objects.