
SQL
tplina
这个作者很懒,什么都没留下…
展开
-
启动/关闭MySQL服务bat命令
@echo offecho 获取Administrator权限cacls.exe "%SystemDrive%\System Volume Information" >nul 2>nulif %errorlevel%==0 goto Adminif exist "%temp%\getadmin.vbs" del /f /q "%temp%\getadmin.vbs"echo...原创 2019-02-18 10:54:58 · 2969 阅读 · 0 评论 -
关于SQL优化的小知识
负向查询不命中索引不命中select account from user where id not in (1,2,3);复制代码命中select account from user where id in (4,5,6);复制代码前置模糊查询不命中索引不命中select account from user where name like '%lufei'复...转载 2019-02-20 09:43:45 · 170 阅读 · 0 评论