Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
A Small Perl Program involving mysql I need help with.
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; -
A Small Perl Program involving mysql I need help with.
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... -
-
command line argument
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? -
trying to perform an update between tables
thanks, i'll take it from here. -
trying to perform an update between tables
I don't want you to program for me, but are there any ways to get around this in MYSQL? -
trying to perform an update between tables
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 =... -
-
Column count doesn't match value count at row 1
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...
