command line argument

[tollbooth]

I know there is no way to do this:

update notfoundinmimports,mhimports
set
notfoundinmhimports.found = 'y'
where
notfoundinmhimports.original_sym = mhimports.tradesymbol;

However, is there a way to achieve the above via a command line argument?

 

[sleipnir214]

First of all, you can't update more than one table at a time.

Second, from what OS are you attempting to performt he update? ______________________________________________________________________
TANSTAAFL!

 

[tollbooth]

UNIX

 

[sleipnir214]

Then something like

echo "UPDATE....." | mysql [databasename]

should do it. ______________________________________________________________________
TANSTAAFL!