新增用户

CREATE USER '{username}'@'%' IDENTIFIED BY '{password}';
GRANT ALL PRIVILEGES ON `{database}`.* TO '{username}'@'%';
FLUSH PRIVILEGES;

创建数据库

CREATE DATABASE `{database}` CHARACTER SET utf8;

SQL函数

日期转换

DATE_FORMAT(your_column, '%Y%m%d')