CodeKeyboard

Set user email and name after removing previous all :   git config --global --replace-all user.email "new@mail.com" git config --global --replace-all user.name "newname" Set user email and name :  git config --global --user.name "setname" git config --global --user.email "set@mail.com" Show current user email and name :  git config --global --user.name git config --global --user.email

CREATE TABLE `std`(`id` int(11) NOT NULL AUTO_INCREMENT,`name` VARCHAR(20) DEFAULT NULL, PRIMARY KEY(`id`));

Generally :  php -S localhost:8000 Laravel :  php artisan serve  [Port number will be atomically 8000] php artisan serve --port=8888 [Run on custom port]  php artisan serve --host=192.168.152.160 --port=8800  [Run on custom IP and custom port] 

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;

SELECT SUBSTRING_INDEX(user_full_name,' ',1) as first_name, SUBSTRING_INDEX(user_full_name,' ',-1) as last_name FROM users WHERE id=1;