求助求助，MySQL学生数据表

创建数据库
 CREATE DATABASE mysqltest;

建表参考代码

CREATE TABLE `onlinepay`  (
  `orderNo` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `payMoney` float(11, 2) NULL DEFAULT NULL,
  `payTime` timestamp(0) NULL DEFAULT NULL,
  `studId` int(11) NULL DEFAULT NULL,
  `examBatchId` int(11) NULL DEFAULT NULL,
  `payType` int(11) NULL DEFAULT NULL COMMENT '支付类别(1=微信）',
  `baoKaoResultIds` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`orderNo`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

--1 
create database mysqltest
--2
use mysqltest
--3
CREATE TABLE IF NOT EXISTS `student`(
   `sid` INT UNSIGNED AUTO_INCREMENT,
   `sname` VARCHAR(50) NOT NULL,
   `gid` INT(20) NOT NULL,
   PRIMARY KEY ( `sid` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
--4
desc student
--5
insert into student (`sid`,`sname`,`gid`) values (1,'王红', 1);
insert into student (`sid`,`sname`,`gid`) values (2,'李强', 1);
insert into student (`sid`,`sname`,`gid`) values (3,'赵四', 2);
insert into student (`sid`,`sname`,`gid`) values (4,'郝娟', 2);
insert into student (`sid`,`sname`,`gid`) values (5,'段然', 3);
insert into student (`sid`,`sname`,`gid`) values (6,'李娟', 3);
--6
CREATE TABLE IF NOT EXISTS `grade`(
   `id` INT UNSIGNED AUTO_INCREMENT,
   `name` VARCHAR(50) NOT NULL,
   PRIMARY KEY ( `id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
--7
insert into `grade` (`id`,`name`) values (1,'软件一班');
insert into `grade` (`id`,`name`) values (2,'软件二班');
insert into `grade` (`id`,`name`) values (3,'软件三班');
--8
show tables;
--9
select id from grade where `name` = '软件一班'；
--10
select * from student where `gid` = 1;
--11
delete from student where `sname` = "王红";
--12
update student set `gid` = 2 where `sname` = '李强';
--13
select `sid`.`sname` from student where `gid` = 2;
--14
create view student_view as (select * from student);
--15
ALTER TABLE student ADD UNIQUE ( `sname` ) 

嘿嘿