mysql - How to group_concat() and group by with null values? -


i have 2 tables this:

publications

publications id        |  publications field id | publications description 1000                   |  1                     | john  1000                   |  2                     | 2014 1000                   |  4                     | aa@... 1000                   |  6                     | 123-456-789

id = 1000 means 1 book , detail description (author name, year, e-mail,tel)

registry

   publications field id  | component     1                      | author name     2                      | year     3                      | date     4                      | e-mail     5                      | price     6                      | tel

registry means book's format table

i want merge 2 tables this:

publications id | publications description 1000            | john,2014,null,aa@..,null,123-456-789

null means book(id=1000)'s field id 3 , 5 null

so, use left join:

select registry.publications field id,component,publications id, publications description registry  left join  publications on publications.publications field id = registry.publications field id

but result is:

publications field id  | component   | publications id   | publications description 1                      | author name | 1000              | john 2                      | year        | 1000              | 2014 3                      | date        | null              | null 4                      | e-mail      | 1000              | aa@.. 5                      | price       | null              | null 6                      | tel         | 1000              | 123-456-789

i know next step use group_concat(ifnull(publications description,'null')) how group publications id? when publications id null?


Comments

Post a Comment

Popular posts from this blog

Python Kivy ListView: How to delete selected ListItemButton? -

Image
i'm trying learn kivy building simple todo-list app suggested dusty phillips, author of book "creating apps in kivy". this code far: from kivy.app import app kivy.uix.boxlayout import boxlayout kivy.properties import objectproperty kivy.uix.listview import listitembutton class taskbutton(listitembutton): pass class todoroot(boxlayout): task_input = objectproperty() task_list = objectproperty() def add_task(self): self.task_list.adapter.data.extend([self.task_input.text]) self.task_list._trigger_reset_populate() def del_task(self): pass class todoapp(app): def build(self): return todoroot() if __name__ == '__main__': todoapp().run() and kv file: #: import main todo #: import listadapter kivy.adapters.listadapter.listadapter #: import listitembutton kivy.uix.listview.listitembutton todoroot: <todoroot>: orientation: "vertical" task_input: task_input_view t...
Read more

ruby - How do I merge two hashes into a hash of arrays? -

http://codepad.org/wmyzqlis i'd merge these 2 arrays: a = { :a => 'a', :b => 'b', :d => 'd' } b = { :a => '1', :b => 'b', :c => 'c' } into hash looks this: {:a => ["a", "1"], :b => ["b", "b"], :c => [nil, "c"], :d => ["d", nil] } this doesn't work: p a.merge(b) { |k, v1, v2| [v1, v2] } # {:c=>"c", :a=>["a", "1"], :b=>["b", "b"], :d=>"d"} it's because hash#merge call block duplicate keys. a = { :a => 'a', :b => 'b', :d => 'd' } b = { :a => '1', :b => 'b', :c => 'c' } hash[(a.keys|b.keys).map { |key| [key, [a.fetch(key, nil), b.fetch(key, nil)]] }] # => {:a=>["a", "1"], :b=>["b", "b"], :d=>["d", nil], :c=>...
Read more