[SQL]SELECT
	id,sq_resident_id
FROM
	sq_resident_family_info
GROUP BY sq_resident_id

[Err] 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xyzj_sql_0320.sq_resident_family_info.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT DATE_FORMAT(NOW(), '%Y') - SUBSTRING('370687199005050000',7,4) AS age FROM table_name

cd /data
mkdir svnrepos
svnadmin create /data/svnrepos/myproject

Docker CLI 客户端，用来运行docker引擎创建镜像和容器
Docker Machine. 可以让你在windows的命令行中运行docker引擎命令
Docker Compose. 用来运行docker-compose命令
Kitematic. 这是Docker的GUI版本
Docker QuickStart shell. 这是一个已经配置好Docker的命令行环境
Oracle VM Virtualbox. 虚拟机

server
    {
        listen 80;
        server_name 域名;
        index index.html index.htm index.php default.html default.htm default.php;
        root  /home/wwwroot/域名/public;
    
    location / {
          index  index.php index.html index.htm;
          #如果请求既不是一个文件，也不是一个目录，则执行一下重写规则
          if (!-e $request_filename)
          {
             #地址作为将参数rewrite到index.php上。
             rewrite ^/(.*)$ /index.php?s=$1;
             #若是子目录则使用下面这句，将subdir改成目录名称即可。
             #rewrite ^/subdir/(.*)$ /subdir/index.php?s=$1;
          }
        }
        location ~ \.php(.*)$ {
            fastcgi_pass   unix:/tmp/php-cgi.sock;
            fastcgi_index  index.php;
            #fastcgi_split_path_info ^(.+\.php)(.*)$;
            #fastcgi_param   PATH_INFO $fastcgi_path_info;
            fastcgi_param  SCRIPT_FILENAME   $document_root$fastcgi_script_name;
            include        fastcgi_params;
        }
    
        location ~ .*\.(gif|jpg|jpeg|png|bmp|swf)$
        {
            expires      30d;
        }

        location ~ .*\.(js|css)?$
        {
            expires      12h;
        }

        location ~ /.well-known {
            allow all;
        }

        location ~ /\.
        {
            #deny all;
        }

        access_log  /home/wwwlogs/access.log2.log;
    }