班级成员表

/*
Navicat MySQL Data Transfer

Source Server : localhost_3306
Source Server Version : 50558
Source Host : localhost:3306
Source Database : 表

Target Server Type : MYSQL
Target Server Version : 50558
File Encoding : 65001

Date: 2017-10-22 16:05:49
*/

SET FOREIGN_KEY_CHECKS=0;

---

– Table structure for 班级成员表

---

DROP TABLE IF EXISTS 班级成员表;
CREATE TABLE 班级成员表 (
ID int(255) NOT NULL AUTO_INCREMENT,
code varchar(255) DEFAULT NULL,
name varchar(255) DEFAULT NULL,
class varchar(255) DEFAULT NULL,
age int(11) NOT NULL,
price decimal(10,2) DEFAULT NULL,
PRIMARY KEY (ID)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

---

– Records of 班级成员表

---

INSERT INTO 班级成员表 VALUES (‘1’, ‘01’, ‘张三’, ‘c1’, ‘18’, ‘1000.00’);
INSERT INTO 班级成员表 VALUES (‘2’, ‘02’, ‘李四’, ‘c2’, ‘19’, ‘5502.00’);
INSERT INTO 班级成员表 VALUES (‘3’, ‘03’, ‘王五’, ‘c2’, ‘16’, ‘5654.00’);
INSERT INTO 班级成员表 VALUES (‘4’, ‘04’, ‘赵六’, ‘c1’, ‘21’, ‘4895.00’);
INSERT INTO 班级成员表 VALUES (‘5’, ‘05’, ‘王琪’, ‘c3’, ‘15’, ‘545.00’);