Skip to content

Instantly share code, notes, and snippets.

@LeandroLS

LeandroLS/GROUP_CONCATnoMySQL3

Created June 24, 2017 17:37
Show Gist options
  • Save LeandroLS/8991666b299e18f3719a9bd45738bef2 to your computer and use it in GitHub Desktop.
Save LeandroLS/8991666b299e18f3719a9bd45738bef2 to your computer and use it in GitHub Desktop.
Download ZIP
Post GROUP_CONCAT()noMySQL
Raw
GROUP_CONCATnoMySQL3
SELECT contas.nome AS conta, classificacao.nome AS classificacao FROM contas INNER JOIN classificacao ON classificacao.id = contas.id_classificacao;
+-----------------------------+---------------+
| conta | classificacao |
+-----------------------------+---------------+
| Salario | receita |
| Rendimento de investimentos | receita |
| Recebimento de aluguel | receita |
| Conta de água | despesa |
| Conta de luz | despesa |
| Jogos da Steam | despesa |
+-----------------------------+---------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment