mysql - Conditional SQL report -

-

suppose have table contains:

serial#  colorcount   bwcount ============================== 12345            23        56 80023             0       459 22903             1       999

and want generate report looks like:

sn     description    value ============================== 12345  "bwcount"      56 12345  "colourcount"  23 80023  "bwcount"      459 22903  "bwcount"      999 22903  "colourcount"  1

so that...

  1. the bwcount , colourcount values output different rows, and
  2. if colourcount value device (sn) 0 not output

is possible raw sql? , if yes, please show me how or point me in right direction. i've done work mysql simple queries. have never seen done before.

you union 2 queries return data need, example:

select serial, 'bwcount' description, bwcount value serial  union select serial, 'colourcount' description, colourcount value serial  colourcount > 0

demo: http://sqlfiddle.com/#!9/f97b6/3


Comments

Post a Comment

Popular posts from this blog

Android : Making Listview full screen -

-
<linearlayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" tools:context=".mainactivity"> <edittext android:layout_margintop="5dp" android:layout_width="match_parent" android:layout_height="50dp" android:background="@drawable/location_edittext" android:id="@+id/locationeditext" android:textsize="15sp" android:textcolor="#999" android:paddingleft="15dp" /> <com.example.ravi_gupta.slider.viewpagercustomduration android:layout_width="wrap_content" android:layout_height="0dp" android:id="@+id/viewpager" android:scrollbarstyle="outsideoverlay" android:layout_weight="0.5...
Read more

javascript - Parse JSON from the body of the POST -

-
i'm using cameratag.com record video on website. service can send json response server can save data database. don't know how proceed here: the documentation states please note json repsonse passed in body of post , not form parameters. here example of how parse response in ruby: data = json.parse(request.raw_post) video_uuid = data["uuid"] but don't know how data on javascript. i'm not experienced in js please bare me :) post sample: { "uuid": "00012710-4b65-0131-ffe6-22000a499ea4", "camera_uuid": "98373a20-79ee-0130-3e42-1231390fcc11", "created_at": "2013-12-20t05:25:02.000z", "percent_complete": 100, "short_code": "kktb4q", "metadata": { }, "state": "published", "recorded_from": "http://singwho.com", "publish_type": null, "formats": [ { "name...
Read more

python - No response in ssh.exec_command in paramiko -

-
i trying use python paramiko execute commands on remote server. when run following commands prompt , appears have succeeded prompt back >>> import paramiko >>> ssh = paramiko.sshclient() >>> ssh.set_missing_host_key_policy(paramiko.autoaddpolicy()) >>> ssh.connect('a.b.c.d', username='server', password='xyz') >>> the response when try execute command [] >>> stdin, stdout, stderr = ssh.exec_command("host") >>> stdout.readlines() [] almost command gives same output. command "host" when ssh executed shell gives several lines of usage output i error if don't give password >>> ssh.connect('a.b.c.d', username='server') traceback (most recent call last): file "<stdin>", line 1, in <module> file "build\bdist.win32\egg\paramiko\client.py", line 307, in connect file "build\bdist.win32\egg\paramiko\client.py...
Read more