Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jul 18th, 2012  |  syntax: None  |  size: 0.40 KB  |  hits: 14  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Error when using GROUP_CONCAT?
  2. mobile(id, name)
  3. mobile(1, 'Nokia')
  4. mobile(2, 'Samsung')
  5. mobile(3, 'Motorola')
  6.        
  7. categories(id, name, mobile_id)
  8. categories(1, 'mobile', '1,2,3')
  9.        
  10. SELECT cat.name as cat_name, GROUP_CONCAT(mobile.name) as mobile_name
  11. FROM `mobile` as mobile
  12. LEFT OUTER JOIN `categories` AS cat ON cat.mobile_id = mobile.id
  13.        
  14. (1,"mobile","Nokia,Samsung,Motorola")
  15.        
  16. GROUP cat.name
create a new version of this paste RAW Paste Data