Search results for query: *

Sorry for the confusion, I meant table A and table B in the same database. I'm trying to do the following which is not supported in MySQL: update tableB, tableA set tableB.z = 'y' where tableB.x = tableA.x;

First, I'm not a PERL programmer, however I am in a quandry and need help. I am using MySQl and it does not support subselects. I have 2 databases - let's call A and B. Within database A, I have a field, x. Within database B, I have fields x, y, and z. What I need to do is take field x in...

UNIX

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?

thanks, i'll take it from here.

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

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 =...

Thanks! Got it.

I'm fairly new to Mysql and am trying to execute the following command: insert into mhmissing(transid, recordid, clearingfirm, account, putcall, symbol, expiryear, expirmonth, strikedollar, strikefrac, longshort, securitytype, tradeprice, netposition, cusip, recordtype, tradesymbol, expirday...