DROP DATABASE IF EXISTS "cloudDept8001" ;
CREATE DATABASE cloudDept8001 CHARACTER SET UTF8 ;
USE cloudDept8001 ;
CREATE TABLE dept (
  deptno BIGINT AUTO_INCREMENT,
  dname VARCHAR(50) ,
  loc VARCHAR(50) ,
  CONSTRAINT pk_deptno PRIMARY KEY(deptno)
) ;
INSERT INTO dept(dname,loc) VALUES ('开发部',database()) ;
INSERT INTO dept(dname,loc) VALUES ('财务部',database()) ;
INSERT INTO dept(dname,loc) VALUES ('市场部',database()) ;
INSERT INTO dept(dname,loc) VALUES ('后勤部',database()) ;
INSERT INTO dept(dname,loc) VALUES ('公关部',database()) ;