索引和事务

在这里插入图片描述

CREATE TABLE `student` (
  `studentid` char(10) NOT NULL,
  `studentname` varchar(10) NOT NULL,
  `gender` varchar(20) DEFAULT NULL COMMENT '男',
  `age` int(11) DEFAULT NULL,
  `birthday` datetime NOT NULL,
  `studentno` varchar(18) NOT NULL,
  `classid` int(11) NOT NULL,
  `begintime` datetime NOT NULL,
  `phone` varchar(20) NOT NULL,
  `city` varchar(20) DEFAULT NULL,
  `email` varchar(50) NOT NULL,
  `dormitoryno` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`studentid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;