CREATE
TABLE
`grades` (
`id`
int
(20)
NOT
NULL
AUTO_INCREMENT,
`student_id`
int
(20)
NOT
NULL
,
`subject`
varchar
(20)
COLLATE
utf8_bin
DEFAULT
NULL
,
`grades`
varchar
(20)
COLLATE
utf8_bin
DEFAULT
NULL
,
PRIMARY
KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4
DEFAULT
CHARSET=utf8
COLLATE
=utf8_bin;
insert
into
`grades`(`id`,`student_id`,`subject`,`grades`)
values
(1,1,
'语文'
,
'80'
),(2,1,
'数学'
,
'89'
),(3,2,
'语文'
,
'90'
);
CREATE
TABLE
`student` (
`id`
int
(20)
NOT
NULL
AUTO_INCREMENT,
`
name
`
varchar
(20)
COLLATE
utf8_bin
DEFAULT
NULL
,
PRIMARY
KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4
DEFAULT
CHARSET=utf8
COLLATE
=utf8_bin;
insert
into
`student`(`id`,`
name
`)
values
(1,
'xiaoming'
),(2,
'xiaohong'
),(3,
'xiaobai'
);