How to select just the cols which are NOT NULL ? mysql -



How to select just the cols which are NOT NULL ? mysql -

i have table :

=================== col1 | col2 | col3| ------------------- 1 null 1 1 1 1 null null 1 . . .

i want write query homecoming $result , $result equal :

$result[0]{ "col1":1 , "col3":1 }; $result[1]{ "col1":1 , "col2":1 , "col3":1 }; $result[2]{ "col3":1 };

how ?

mysql

Comments

Post a Comment

Popular posts from this blog

ruby on rails - Devise Logout Error in RoR -

ruby on rails - Devise Logout Error in RoR - while using devise in ror, encountering unusual error when trying log out url different root url. displays me : actioncontroller::invalidauthenticitytoken in devise::sessionscontroller#destroy" for illustration if rooting path after log in '/structure', , seek log out '/general' error, while logging out '/structure' fine. any help highly appreciated. ruby-on-rails ruby devise
Read more

model view controller - MVC Rails Planning -

model view controller - MVC Rails Planning - i'm starting rails , i'm building app stores films info, user can watch film , give grade on web application. i have coded cinema model, controller , views. now, have 2 questions: should need create model , controller grading? in case, should create or should wait , create first users model , controller? yes, on model , controller grades. that'd feasible way maintain track of who's graded what. it's create first, i'd start users, since grades depend on both films , users. ruby-on-rails model-view-controller
Read more

php - Working with pretty urls on apache and fastcgi after hhvm installation -

php - Working with pretty urls on apache and fastcgi after hhvm installation - i needed slim php work pretty urls using .htaccess , no problem. rewriteengine on rewritecond %{request_filename} !-f rewriterule ^ index.php [qsa,l] now ran using hhvm, fastcgi using virtual host config. <virtualhost *:80> servername project.dev serveralias www.project.dev documentroot /var/www/project proxypassmatch ^/(.*\.php(/.*)?)$ fcgi://127.0.0.1:9000/var/www/project/$1 <directory "/var/www/project"> allowoverride order allow,deny allow </directory> </virtualhost> of course, won't read .htaccess file, thought of adding .htaccess config in virtual host config, no, won't work. like so: <virtualhost *:80> servername project.dev serveralias www.project.dev documentroot /var/www/project proxypassmatch ^/(.*\.php(/.*)?)$ fcgi://127.0.0.1:9000/var/www/project/$1 <directory "/var/www/project"...
Read more