Git error: Your local changes to the following files would be overwritten by merge

To fix this error type:

git reset --hard HEAD

Nginx block default

server {
  return 404;
}

SQL select where join not existed; Select where can't join

SELECT t1.ID
FROM Table1 t1
    LEFT JOIN Table2 t2 ON t1.ID = t2.ID
WHERE t2.ID IS NULL

source: http://stackoverflow.com/a/4076157/1767461

Installing mail (sendmail) Ubuntu 16

sudo apt-get install sendmail

And now you can send mails easy with tls enabled without any other bullshit configs

Laravel 5.3 Nginx Config

    server {
            listen 80;
            listen [::]:80;

            root /var/www/laravel/public;
            index index.php index.html index.htm;

            server_name my_app.dev;

            location / {
                    try_files $uri $uri/ /index.php?$query_string;
            }
            location ~ \.php$ {
              include snippets/fastcgi-php.conf;
              fastcgi_pass unix:/run/php/php7.0-fpm.sock;
            }

            location ~ /\.ht {
                deny all;
            }

Reload MySql

This should work on ubuntu 18.04

sudo service mysql restart

If not you can try other commands:

sudo systemctl restart mysqld

sudo systemctl restart mysql

or

sudo service mysqld restart

sudo service mysql restart

or

sudo /etc/init.d/mysql reload

or

sudo /etc/init.d/mysql force-reload

Change Auto Increment counter in MySQL

ALTER TABLE tbl AUTO_INCREMENT=310;