perceptive558的博客

@echo =======添加环境变量========= set sqlPath=C:\Program Files\MySQL\MySQL Server 8.0\bin\ set path=%path%;%sqlPath% @echo ======new environment========= @echo %path% @echo ======数据库设置========= mysql -u ...

为了防止自己忘记，也为了感谢帮助过我的人 1. 分时查询 a. 分时查询挂镀线 条 产量 SELECT DATE_FORMAT(intime, '%Y-%m-%d %H:00:00') AS time, sum(replace(num, '条', '')) as '分时数量' FROM factorymanager.warehouse where ...