AYUKiss的博客

修改mysql配置文件，然后添加 skip-name-resolve，跳过解析 [mysqld] skip-name-resolve

SELECT d.index as days,d.date as time,COUNT(a.id) as count_num FROM( SELECT @a :=@a + 1 as `index`, DATE(ADDDATE(CURRENT_DATE, INTERVAL @a DAY)) AS `date` FROM mysql.help_topic,(SELECT @a := 0) temp WHERE @a < 6 - WEEKDAY(CURRENT_DATE) UNION SELECT @s :

下载地址 不要安装错了，不然初始化数据库的时候会报错 解压 tar -xvf 文件名 移动并重命名一下 mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql 配置my.cnf vim /etc/my.cnf [mysqld] bind-address=0.0.0.0 port=3306 user=root basedir=/usr/local/mysql datadir=/data/mysql socket=/tmp/mysql.sock l

去重 # 查询员工表涉及到的部门编号 SELECT DISTINCT department_id FROM employees 示例： concat 连接字段 逻辑运算符 or in 判断某字段的值是否属于in列表中的某一项 #查询员工表jobid等于AD_VP，AD_PRES的员工姓名 SELECT last_name,job_id FROM employees WHERE job_id='AD_VP' OR job_id='AD_PRES' #使用in 等价于or SELECT last_