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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Baukep
-
Trying to calculate a moving average and updating a table with it
The UPDATE query Bauke -
Trying to calculate a moving average and updating a table with it
I changed it and now the third query return more then one row (more tickers I think). How do I accomplish that it only gives the ticker that is cuurently updated. Excuse my English. Hope you understand what I mean. Bauke -
Trying to calculate a moving average and updating a table with it
This one works: SELECT @hdat:= (SELECT DISTINCT DATE_FORMAT(datum, '%Y-%m-%d') FROM koersen ORDER BY datum DESC LIMIT 0,1); SELECT @ldat:= (SELECT DISTINCT DATE_FORMAT(datum, '%Y-%m-%d') FROM koersen ORDER BY datum DESC LIMIT 9,1); SELECT tickerVL, MAvolume FROM ( SELECT k.tickerVL... -
Trying to calculate a moving average and updating a table with it
With this query I get the values I want: SELECT @hdat:= (SELECT DISTINCT DATE_FORMAT(datum, '%Y-%m-%d') FROM koersen ORDER BY datum DESC LIMIT 0,1); SELECT @ldat:= (SELECT DISTINCT DATE_FORMAT(datum, '%Y-%m-%d') FROM koersen ORDER BY datum DESC LIMIT 9,1); SELECT tickerVL, MAvolume FROM (... -
Trying to calculate a moving average and updating a table with it
Sorry Andrew, In my last answer I talked about the third query! You are completely right for the second! Thanks a lot! Bauke -
Trying to calculate a moving average and updating a table with it
Hello Andrew, No, I indeed need the ten records to total the volume and get the average from that. That average (MA) is the average for the last date. For the next day the avg of the ten newest date is used. Hope you understand my English Bauke -
Trying to calculate a moving average and updating a table with it
Hello, I'm learning SQL and now I'm trying to update a table (koersen) with stockdata (date, ticker, open, close, volume, MA10vol). The column MA10vol is empty and should contain the avg volume from the last ten records with the same ticker. What I tried sofar: SELECT @hdat:= (SELECT DISTINCT... -
Update problem with replace into
Hello, I'm using this query: LOAD DATA INFILE 'D:/Effectenbeheer/Koersen/Koersen_update.vsn' REPLACE INTO TABLE allekoersen_2006el FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (tickerVL,valuta,datum,open,hoog,laag,slot,volume); to update the table... -
UPDATE
Hello, My problem is the following (apart from being a newbie): I'm trying to get all my banktransactions (from csv-files from my bank) into MySQL (5.0.33). I managed to do that. Now I have to update the 'target'-base because some fields don't have the right values (ie INC should be changed to... -
Query result as column name?!?
Thanks again! But now I get 1271 Illegal mix of collations for operation 'Union'. I looked it up but I don't understand it. I'm always using the same base and have never changed a collation. Working with XAMPP (latest version)and Navicat as a query and reporting tool. Is it possible to set the... -
Query result as column name?!?
Thanks Rudy, Looks great but I get the error 1221 Incorrect usage of UNION and ORDER BY Any idea what's wrong? (I copied and pasted it) Bauke -
Query result as column name?!?
Sorry, here it is. It's very simple because most of the work is done in producing the view. SELECT Seizoen , Naam , Winstperc FROM winnaars WHERE Seizoen=(SELECT(MAX(w_seizoen)) FROM wedstrijden) ORDER BY Winstperc DESC LIMIT 3 Bauke -
Query result as column name?!?
Hello, Back again after several months. Played fine with SQL and most (with a little help from forummembers) went well. I now have made a view with results of several years for all the people in the database. I can query the view to get the three winners, sorted decending on Winstperc. The...
