trying to perform an update between tables

[tollbooth]

Here is what I'm trying to do:

SQL-query :

UPDATE notfoundinmhimports,mhimports
SET
notfoundinmhimports.found = 'y'
WHERE
notfoundinmhimports.original_sym = mhimports.tradesymbol;

MySQL said:
You have an error in your SQL syntax near 'mhimports
SET
notfoundinmhimports.found = 'y'
WHERE
notfoundinmhimpo' at line 1

Can anyone help me out? Thanks in advance!

 

[sleipnir214]

You can only update one table at a time in MySQL. ______________________________________________________________________
TANSTAAFL!

 

[tollbooth]

I don't want you to program for me, but are there any ways to get around this in MYSQL?

 

[sleipnir214]

I'm interpreting your update query as (in English):

For every row in notinmhimports, set it's field "found" to the value "y" when that record's field "original_sym" is equal to the field "tradesymbol" in any record of mhimports.


Your update query screams for a subselect, which unfortunately MySQL does not at this time support.

I would cheat. I'd use a programming language to perform a select which matches your WHERE clause, then loop through the results of that query, updating notinmhimports. ______________________________________________________________________
TANSTAAFL!

 

[tollbooth]

thanks, i'll take it from here.