Para programadores avanzados en mySQL

[Shell Root]

mmm creo que sería más fácil hacerlo desde PHP. Y con un GROUP_CONCAT() así:

Código (sql) [Seleccionar] Expandir

mysql> select group_concat(COLLATION_NAME) from COLLATIONS;

big5_chinese_ci,big5_bin,dec8_swedish_ci,dec8_bin,cp850_general_ci,cp850_bin,hp8_english_ci,hp8_bin,koi8r_general_ci,koi8r_bin,latin1_german1_ci,latin1_swedish_ci,latin1_danish_ci,latin1_german2_ci,latin1_bin,latin1_general_ci,latin1_general_cs,latin1_spanish_ci,latin2_czech_cs,latin2_general_ci,latin2_hungarian_ci,latin2_croatian_ci,latin2_bin,swe7_swedish_ci,swe7_bin,ascii_general_ci,ascii_bin,ujis_japanese_ci,ujis_bin,sjis_japanese_ci,sjis_bin,hebrew_general_ci,hebrew_bin,tis620_thai_ci,tis620_bin,euckr_korean_ci,euckr_bin,koi8u_general_ci,koi8u_bin,gb2312_chinese_ci,gb2312_bin,greek_general_ci,greek_bin,cp1250_general_ci,cp1250_czech_cs,cp1250_croatian_ci,cp1250_bin,cp1250_polish_ci,gbk_chinese_ci,gbk_bin,latin5_turkish_ci,latin5_bin,armscii8_general_ci,armscii8_bin,utf8_general_ci,utf8_bin,utf8_unicode_ci,utf8_icelandic_ci,utf8_latvian_ci,utf8_romanian_ci,utf8_slovenian_ci,utf8_polish_ci,utf8_estonian_ci,utf8_spanish_ci,utf8_swedish_ci,utf8_turkish_ci,utf8_czech_ci,utf8_danish_ci,utf8_lithuanian_ci,utf8_ |

1 row in set, 1 warning (0.00 sec)

mysql>

[nicknamex]

Tienes razón Shell Root, he estado revisando GROUP_CONCAT() y parece ser la respuesta para todos mis problemas. En mi ejemplo sería:

Código [Seleccionar] Expandir

SELECT id, nombre, apellido, GROUP_CONCAT(Registro)
FROM Tabla
WHERE id>30
GROUP BY id y me sale lo que quiero . Gracias.