40 PM
Subject: Re: UPDATE from monthly to yearly rows
Cor,
>I need to put all available monthly Values from Updates
>to 1 Data record where MyKey and Year are equal.
IOW you want to save the results of the business end of a crosstab (pivot
table) query. The
crosstab analysis wil
Cor,
>I need to put all available monthly Values from Updates
>to 1 Data record where MyKey and Year are equal.
IOW you want to save the results of the business end of a crosstab
(pivot table) query. The
crosstab analysis will require a full query. MySQL has an INSERT ...
SELECT command,
b
Hi List,
Please help me with the following problem in MySQL 5.0.15.
I have 2 MyISAM tables like:
- table Updates with fields myKey, Year, Month, Value
where Month has the values 1 .. 12
- table Data with fields myKey, Year, Jan, Feb, ... Dec
I need to put all available monthly Values from U
