MySQL之表的创建与表的结构

1 .创建表

CREATE TABLE `course` (
  `课程号` char(5) NOT NULL,
  `课程名称` varchar(30) DEFAULT NULL,
  `课程简介` text,
  `课时` int(11) DEFAULT NULL,
  `学分` int(11) DEFAULT NULL,
  `开课学期` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`课程号`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `sc` (
  `学号` char(9) NOT NULL,
  `课程号` char(5) NOT NULL,
  `成绩` decimal(4,1) DEFAULT NULL,
  PRIMARY KEY (`学号`,`课程号`),
  KEY `fkch` (`课程号`),
  CONSTRAINT `fkch` FOREIGN KEY (`课程号`) REFERENCES `course` (`课程号`),
  CONSTRAINT `fxh` FOREIGN KEY (`学号`) REFERENCES `student` (`学号`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `student` (
  `学号` char(9) NOT NULL,
  &