On Sat, 15 May 2010 00:55:14 +0200, Przemysław (HaCeK) Bryniak hacus@tlen.pl wrote:
Nie chce byc namolny czy cos, ale CREATE VIEW vnodes_mac AS SELECT nodeid, GROUP_CONCAT(mac SEPARATOR ',' ORDER BY id) AS mac FROM macs GROUP BY nodeid zwraca mi #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
near
'ORDER BY id) AS mac FROM macs GROUP BY nodeid' at line 2
A takie dziala CREATE VIEW vnodes_mac AS SELECT nodeid, GROUP_CONCAT(mac SEPARATOR ',' ) AS mac FROM macs GROUP BY nodeid ORDER BY id
A takie coś działa? CREATE VIEW vnodes_mac AS SELECT nodeid, GROUP_CONCAT(mac ORDER BY id SEPARATOR ',') AS mac FROM macs GROUP BY nodeid;
Pozdrawiam :)