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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Update query question
Can anyone tell me what is wrong with this? UPDATE sales t2 INNER JOIN (SELECT (t1.commission rate * t2.amount) as commission FROM salesreps t1, sales t2) t1 ON t1.rep = t2.rep SET t2.commission = commission; I get this error. ERROR 1054 (42S22): Unknown column 't1.rep' in 'on clause' -
Update query question
Sorry, I should have been more specific on what I am trying to do. Here's my table. AvgSaleslastweek is the value I am trying to write back into the table. Date Salesperson Amount AvgSaleslastweek 1/1/05 Bob 50 50 1/2/05 Jon 100... -
Update query question
What is the best way to replicate a column from one table to another table dynamically so that as values in table one change they are reflected in table 2? I ask because I am trying to calculate values for a field based on other fields in the same table. When I try to do so I get this error... -
Update query question
Sorry, I should have been more specific on what I am trying to do. Here's my table. AvgSaleslastweek is the value I am trying to write back into the table. Date Salesperson Amount AvgSaleslastweek 1/1/05 Bob 50 50 1/2/05 Jon 100... -
Update query question
I have some transactional type data in a table. I am trying to update columns in that table with calculated values based on the data in the same table, but evidently I am unable to write a lookup value to the same table referenced in the subquery I am using to generate the value to be written... -
sql - question
Dumb question. I have been browsing through a lot of SQL tutorials but am not sure how this is done, and hoped someone could point me in the right direction. Table is: person date amount Bob 2005-05-10 50 Tom 2005-05-10 100 Bob 2005-05-09 75 Tom... -
Query Browser
I am looking for graphical query tool to work with MySQL 4.1. I installed a copy of their query browser, but get the following error. MySQL Error Nr. 1251 Client does not support authentication protocol requested by server; consider upgrading MySQL client Anyone have any insight into this... -
start mysql at boot on solaris box
Not sure about Solaris, but setting this up on Mandrake, it required an entry in /etc/rc.local. -
Write modified date of imported file into the table?
I am trying to setup a process whereby a text file is imported into a table daily. It would simplify my life greatly to be able to write either the filename, or the file's last modified date, into a seperate column in the table and associated with each row of data imported for the particular...
