CNAHYZ的博客

1.以系统管理员身份运行cmd.2.查看mysql是否已经启动，如果已经启动，就停止：net stop mysql.3.切换到MySQL安装路径下（如果已经配了环境变量，可以不用切换），在命令行输入：mysqld -nt --skip-grant-tablesmysql8.0的命令是：mysqld --console --skip-grant-tables --shared-m...

参考文章:https://blog.youkuaiyun.com/tiantang_1986/article/details/78037804https://blog.youkuaiyun.com/lxxxzzl/article/details/412156091、插入一条数据，存在则不操作，不存在就插入（必须现有唯一键）使用insert ignore语句，例如插入数据：insert ignore in...

原文地址查询语句： SELECT TOP 1000 ST.text AS '执行的SQL语句', QS.execution_count AS '执行次数', QS.total_elapsed_time AS '耗时', QS.total_logical_reads AS '逻辑读取次数', QS.total_logical_w...

参考文章：https://wsdtq123.iteye.com/blog/2270169SELECT count( sno ) count, DATE( date ) signtime FROM (# 构造当前日期之前31天的日期表 SELECT @cdate := date_add(@cdate, INTERVAL - 1 DAY) date ...

select * from intent_student_info isi left join stu_followup_rec_data sfrd on followup_time=(select max(followup_time) from stu_followup...

1.下载https://dev.mysql.com/downloads/mysql/2.安装2.1配置环境变量2.2新建my.ini文件放置在解压根目录下，datadir即为存放数据库文件的目录# For advice on how to change settings please see# http://dev.mysql.com/doc/refman/5.6/en...