DROP DATABASE IF EXISTS "cloudDept8003" ;
CREATE DATABASE cloudDept8003 CHARACTER SET UTF8 ;
USE cloudDept8003 ;
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()) ;