... ja kazem:
mysql> select 'asdf';
+------+
| asdf |
+------+
| asdf |
+------+
1 row in set (0.00 sec)
mysql> select 'asdf' as desc1;
+-------+
| desc1 |
+-------+
| asdf |
+-------+
1 row in set (0.01 sec)
Jel bi sad znao?
Da kompletiram resenje:
Kôd:
INSERT `t2` (id, value_min, value_max, desc_for_min, desc_for_max)
SELECT
id,
MIN(value) as value_min,
MAX(value) as value_max,
'description min' as desc_for_min,
'description max' as desc_for_max
FROM t1
GROUP BY id
ORDER BY id
U datom slucaju ti ne trebaju "as col_name" dodaci, posto je samo bitno da se poklopi broj kolona.
[edit]Napomena: gornji kod je sve jedan query, da se neko ne zbuni
[/edit]