Search results for query: *

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

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

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

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

I have the following query. It gives me every time the most recent standings in this seisons competition. Is there a way to update another table with the results of this query? The code should be (I think): UPDATE standen SET speler = speler, jaarweek = MAX(JaarWeek), stand = Stand SELECT...

Back again with a newbie question. I have a table with three fields: speler, jaarweek, stand 1,"2006-38", 1 1,"2006-39", 2 2,"2006-38", 2 2,"2006-39", 3 What I an trying to do is to get a query that gives me: speler, 2006-38, 2006-39 1,1,2 2,2,3 I tried CASE, IF(), IF...THEN but no result I...

Hello, In a WHERE clause I'm using: ....AND w_datum <=('2006-10-26') and it works. But when I use: AND w_datum <= DATE_ADD(MAX(`wedstrijden`.`w_datum`), INTERVAL -7 DAY) it doesn't. GROUP BY error. It is a query with unions (see below) What am I doing wrong? Thanks in advance Bauke SELECT...

Hello, I couldn't find a function that numbers the resultset of a query. First row should be 1, second row 2 etc. I searched for rownum, rowcount, rowindex etc with and without underscore's. I must be overlooking something and feel rather stupid. Can someone help me here? Bauke

Hello, I'm using Mepis 6.0 with XAMPP (mysql 5.0.24) and I'm completely stuck I think, I have two tables: one for members (id, name, adres etc) and one for the played games (date, season, round, gamenr, member_id1, score, member_id2, score etc) I already have queries in which i calculate the...

Hello, For some reason I cannot answer the first tread with the same name, excluding (2). On all the other messages there is a Reply button ?!? The query is not the problem and maybe this isn't the right forum. The query runs fine in phpmyadmin. Only when I want to export the results to a csv...

Hello, When I try to export a query result to a csv file I get the following: (just a little piece af it). The last row beginning with <span class="syntax">< is very long and printed all on the same row. On one of the last rows is this message: #1305 - FUNCTION biljart.ROUND does not exist...

Hello, Starting to teach myself SQL. Goes fine except that I run into new problems every now and again (as expected ;-). I have 2 tables: 1 Games with 1 record for every game played. Two (different) players with their results. Fields: Gamenr, player1, pl1_points, pl1_turns, player2...

Hello, I starting to teach myself SQL, bought some books and its going good thusfar. But some things don't work as I thought they would ;-( I have 2 tables (MySQL): 1. Games with (amongst others) player1 and player2 in which field are the id's of the player from the players table 2. The...