Re: MySQL 3.23.54 + update

[Taylor Sittler]

Is there any way to update table values based on values in another table?

For instance, given:
<table (column1,column2..)>
Table 1 (jobid, jobname)
Table 2 (person, jobid, jobname)
could I update Table 2, setting jobname=Table1.jobname where 
Table1.jobid=Table.jobid?  Is it possible to do this in one SQL command, 
so that SQL matches the updating set to the stored set?

Thus far I have been performing the updates 1 row at a time using 
python.  This process is exceedingly slow for large tables.  Any help 
would be greatly appreciated.
Thanks
Taylor

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]