Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
MYSQL PIVOT
create temporary table temp(reqtypeid int, reqcode int); insert into temp(reqtypeid, reqcode) values (NULL, 0); insert into temp(reqtypeid, reqcode) values (NULL, 2); insert into temp(reqtypeid, reqcode) values ( 1 , 0); insert into temp(reqtypeid, reqcode) values (1 , 1); insert into temp(reqtypeid, reqcode) values (2 , NULL); insert into temp(reqtypeid, reqcode) values ( 2 , 0); insert into temp(reqtypeid, reqcode) values ( 2 , 1); insert into temp(reqtypeid, reqcode) values ( 3 , 1); insert into temp(reqtypeid, reqcode) values ( 4 , NULL); insert into temp(reqtypeid, reqcode) values ( 4 , 1); select * from temp; drop table temp; SELECT reqtypeid, SUM(CASE WHEN (reqcode='NULL') THEN 1 ELSE 0 END) AS reqcode_null, SUM(CASE WHEN (reqcode='1') THEN 1 ELSE 0 END) AS reqcode_1, SUM(CASE WHEN (reqcode='2') THEN 1 ELSE 0 END) AS reqcode_2, SUM(CASE WHEN (reqcode='0') THEN 1 ELSE 0 END) AS reqcode_0 FROM temp GROUP BY reqtypeid
run
|
edit
|
history
|
help
0
restaurants_menu
Create database sneha;
News Update Denis
lab01
W
compile visitors list for last 8 days
Subrahmanyamk
salamatova
mysql - where (in,like)
MySQL updates first timestamp column automatically