Advertisement
Guest User

Untitled

a guest
Jul 27th, 2017
229
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. SELECT CONCAT('[n\t', GROUP_CONCAT(
  2. COLUMN_JSON(
  3. COLUMN_ADD(
  4. COLUMN_CREATE('mimefile1', mimefile1)
  5. , 'unpacked1', unpacked1
  6. , 'unpacked2', unpacked2
  7. )
  8. ORDER BY mimetype_file1
  9. SEPARATOR ',\n\t'
  10. ), '\n]') AS json
  11. FROM mycool.databasename \G;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement