MySQL-> Multiple same values from a field will be sum and the new field name will be as how I define

By -
Question Explanation : There is a table named people and there is information stored of different people from different country. Now how we can we see how many people form Bangladesh,Canada,Italy or few others country as table view ?

SELECT
SUM(CASE WHEN country_name ='Bangladesh' THEN 1 ELSE 0 END) as Bangladesh,
SUM(CASE WHEN country_name ='Canada' THEN 1 ELSE 0 END) as Canada
from people;

Comments

Post a Comment

Popular posts from this blog

WP register_post_type() with custom CMB2 meta box

By -
functions.php register_post_type('portfolio',[ 'labels'=>[ 'name'=> 'Portfolio', 'add_new_item'=>'Add new portfolio', 'view_item'=>'View portfolio', ], 'public'=>true, 'menu_icon'=>'dashicons-edit', 'menu_position'=>1, 'supports'=> ['title','editor','thumbnail'] ]); custom.php add_action('cmb2_admin_init','custom_metaboxes'); function custom_metaboxes(){ $portfolioMetaBox = new_cmb2_box([ 'object_types'=>['portfolio'], 'id'=>'portfolio-additional-fields', 'title'=>'Portfolio Additional Fields' ]); $portfolioMetaBox->add_field([ 'id'=>'portfolio_designation', 'name'=>'Portfoilo Designation', 'type'=>'text' ]); $portfolioMetaBox->add_field([ 
Read more

Git post receive setup at server for git push to the production from local machine

By -
IN SERVER cd www mkdir repo cd repo mkdir app.website.git cd app.website.git git init –bare cd hooks touch post-receive chmod R 775 post-receive put the following line in post-receive file git --work-tree=/var/www/html/app.website.com --git-dir=/var/www/repo/app.website.git checkout master -f cd /var/www/html/app.website.com nano /etc/hosts 127.0.1.1 app.website.com cd /etc /apach2 /site-available cp 000-deault.conf app.website.com.conf LOCALLY git remote -v git remote add prod-website ssh://root@192.168.0.1:/var/www/repo/app.website.git
Read more