求助求助，MySQL学生数据表

Question

 

Answer 1

创建数据库
 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;