素材:
/*
SQLyog Ultimate v8.32
MySQL - 5.7.14 : Database - db
*/
/*!40101 SET NAMES utf8 */;
/!40101 SET SQL_MODE=‘’/;
/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;
/!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;
/!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=‘NO_AUTO_VALUE_ON_ZERO’ /;
/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;
CREATE DATABASE /!32312 IF NOT EXISTS/db
/*!40100 DEFAULT CHARACTER SET utf8 */;
USE db
;
/*Table structure for table course
*/
DROP TABLE IF EXISTS course
;
CREATE TABLE course (
cs_id int(11) NOT NULL COMMENT ‘课程编号’,
cs_name varchar(50) NOT NULL COMMENT ‘课程名称’,<