一、数据库的增,删,查,改(create drop show alter,后边都要跟database)
1.创建数据库
语法:create {database/schema} [if not exists] 数据库名 character set [=] 字符集;
实例:create database if not exists test2 character set = utf8mb4;
2.查看数据库定义信息
语法:show create database 数据库名;
实例:show create database test2;
3.修改数据库操作
语法:alter database 库名 character set = 字符集;
实例:alter database test2 character set = utf8;
4.删除数据库操作
语法:drop database [if exsist] 库名;
实例:drop database if exists test1;