安装 brew 记录

guofeng@50ed3c1dd5f6 ~ % /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"
==> Checking for `sudo` access (which may request your password).
Password:
==> This script will install:
/opt/homebrew/bin/brew
/opt/homebrew/share/doc/homebrew
/opt/homebrew/share/man/man1/brew.1
/opt/homebrew/share/zsh/site-functions/_brew
/opt/homebrew/etc/bash_completion.d/brew
/opt/homebrew

Press RETURN to continue or any other key to abort
==> /usr/bin/sudo /usr/sbin/chown -R guofeng:admin /opt/homebrew
==> Downloading and installing Homebrew...
HEAD is now at bc370748c Merge pull request #10805 from Homebrew/spdx-update
fatal: Could not resolve HEAD to a revision
Warning: /opt/homebrew/bin is not in your PATH.
==> Installation successful!

==> Homebrew has enabled anonymous aggregate formulae and cask analytics.
Read the analytics documentation (and how to opt-out) here:
  https://docs.brew.sh/Analytics
No analytics data has been sent yet (or will be during this `install` run).

==> Homebrew is run entirely by unpaid volunteers. Please consider donating:
  https://github.com/Homebrew/brew#donations

==> Next steps:
- Add Homebrew to your PATH in /Users/guofeng/.zprofile:
    echo 'eval "$(/opt/homebrew/bin/brew shellenv)"' >> /Users/guofeng/.zprofile
    eval "$(/opt/homebrew/bin/brew shellenv)"
- Run `brew help` to get started
- Further documentation: 
    https://docs.brew.sh
guofeng@50ed3c1dd5f6 ~ % echo 'eval "$(/opt/homebrew/bin/brew shellenv)"' >> /Users/guofeng/.zprofile
    eval "$(/opt/homebrew/bin/brew shellenv)"
guofeng@50ed3c1dd5f6 ~ % vim /Users/guofeng/.zprofile 
guofeng@50ed3c1dd5f6 ~ % brew help
Example usage:
  brew search [TEXT|/REGEX/]
  brew info [FORMULA...]
  brew install FORMULA...
  brew update
  brew upgrade [FORMULA...]
  brew uninstall FORMULA...
  brew list [FORMULA...]

Troubleshooting:
  brew config
  brew doctor
  brew install --verbose --debug FORMULA

Contributing:
  brew create [URL [--no-fetch]]
  brew edit [FORMULA...]

Further help:
  brew commands
  brew help [COMMAND]
  man brew
  https://docs.brew.sh
guofeng@50ed3c1dd5f6 ~ % 

Windows 启动 php-cgi

@echo off 
echo Starting PHP70 FastCGI On 9001... 
cd C:/phpStudy/php/php-7.0.12-nts/
php-cgi.exe -b 127.0.0.1:9001 -c php.ini
@echo off 
if "%1" == "h" goto begin 
	mshta vbscript:createobject("wscript.shell").run("%~nx0 h",0)(window.close)&&exit 
:begin 
::后台运行,下面是你自己的代码。
echo Starting PHP70 FastCGI On 9001... 
cd C:\Software\php-7.4.12-nts-Win32-vc15-x64\
php-cgi.exe -b 127.0.0.1:9001 -c php.ini

SQL Server 一些记录

SQL Server 实现 MySQL group_concat

注释:连表查询时,子表单字段结果拼接

select DISTINCT(o.id),o.*, 
CAST(stuff(( 
SELECT ',' + title FROM t_rm_sealapplycommondetail0 d WHERE d.pid = o.id FOR xml path('')
) , 1 , 1 , '') AS VARCHAR(255)) as titles 
from t_rm_sealapplycommon o  where 1=1