1234567891011121314 |
- 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()) ;
|