常用SQL总结

1、初始化项目（例：myApp）数据库

# 创建数据库，并创建权限用户
create database 'myApp' character set utf8;
create user 'myApp'@'localhost' identified by 'myApp';
grant all privileges on myApp.* to 'myApp'@'localhost';
flush privileges