CodeKeyboard

SELECT CONCAT("'",COLUMN_NAME,"',") FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'undp_liupcp_survey' ORDER BY ORDINAL_POSITION ASC; 

Disable the current php version $ sudo a2dismod php7.0 Restart the apache $ sudo systemctl restart apache2 Enable the expect php version $ sudo a2enmod php7.1 ** If problem arise then the following two line $ sudo apt purge libapache2-mod-php7.1 libapache2-mod-php $ sudo apt install libapache2-mod-php7.1 libapache2-mod-php Enable the expect php version $ sudo a2enmod php7.1 Restart the apache $ sudo systemctl restart apache2 Check the php version $ php -v Finally set the php version $ sudo update-alternatives --set php /usr/bin/php7.1 Check the php version $ php -v Restart the apache2 $ sudo systemctl restart apache2

Basic dump command :  mysqldump -u root -p prod_helpdesk > db_backup.sql Dump command with rename file by date time :  mysqldump -u root -p prod_helpdesk > prefix_$(date +%Y-%m-%d-%H.%M.%S).sql

DB::select("SELECT db1.employees.name AS employee_name, db2.companies.name as company_name FROM db1.employees employees JOIN db2.companies companies ON companies.code = employees.company_code WHERE companies.country = 'Bangladesh' "); Note: Both database users and passwords have to be the same.

git log --oneline -- specific-file-name 85b6998 (Take the hash from head) git checkout 85b6998 specific-file-name

Make sure all files are owned by the Apache group and user. In Ubuntu it is the  www-data  group and user. -  chown -R www-data:www-data /path/to/webserver/www Next enabled all members of the www-data group to read and write files. -  chmod -R g+rw /path/to/webserver/www

Delete a local GIT branch - git branch -d branch_name - git branch -D branch_name Delete a remote GIT branch - git push <remote_name> --delete <branch_name>