DROP DATABASE IF EXISTS clouddb03;

CREATE DATABASE clouddb03 CHARACTER SET UTF8;

USE clouddb03;

CREATE TABLE dept(
	deptno BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
	dname VARCHAR(60),
	db_source VARCHAR(60)

);
INSERT INTO dept(dname,db_source) VALUES ('开发部', DATABASE());
INSERT INTO dept(dname,db_source) VALUES ('人事部', DATABASE());
INSERT INTO dept(dname,db_source) VALUES ( '财务部', DATABASE());
INSERT INTO dept(dname,db_source) VALUES ('市场部', DATABASE());
INSERT INTO dept(dname,db_source) VALUES ('运维部', DATABASE());