创建数据库，用户，赋予远程访问权限

create database linkis default character set utf8;
CREATE USER 'linkis'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON linkis. * TO 'linkis'@'%' IDENTIFIED by '123456';
FLUSH PRIVILEGES;

配置密码策略

set global validate_password_policy=0;
set global validate_password_length=1;
set global validate_password_mixed_case_count=0;
set global validate_password_number_count=3;

生成36位uuid

CONCAT(SUBSTRING(MD5(RAND()),1,8),'-',SUBSTRING(MD5(RAND()),1,4),'-',SUBSTRING(MD5(RAND()),1,4),'-',SUBSTRING(MD5(RAND()),1,4),'-',SUBSTRING(MD5(RAND()),1,12))

• 根据一列更新另一列

update mypot2.produces t set smallPic = 
(
	select t1.smallPic
	FROM
	mypot.json t1
	where t.skuName = t1.skuName
)

列转行unpivot

生成多行

变量使用

select 
  zj_tjsj,
  qymc,
  zj_sl,
  if(@qymc = qymc, @xh := @xh + 1, @xh := 1) as xh,
  if(@xh = 1, @hj := zj_sl, @hj := zj_sl + @hj ) as cs,
  @qymc := qymc
  from
(
select 
  MONTH(ybsj) as zj_tjsj,
  qymc, 
  sum(sjsc) as zj_sl,
  @xh := 0,
  @hj := 0,
  @qymc := null
from 
    zkyk_resource.t_project_ghsj
    group by MONTH(ybsj),qymc
    order by qymc, MONTH(ybsj)
) t