test.sql 479 Bytes
Newer Older
haoyuz3's avatar
haoyuz3 committed
1
create table student (                                                                     
haoyuz3's avatar
haoyuz3 committed
2
provtuple varchar(10),
haoyuz3's avatar
haoyuz3 committed
3
4
5
6
7
name varchar(20),
age integer,
major varchar(20)
);
create table regu (
haoyuz3's avatar
haoyuz3 committed
8
provtuple varchar(10),
haoyuz3's avatar
haoyuz3 committed
9
10
11
name varchar(20),
courseid integer
);
haoyuz3's avatar
haoyuz3 committed
12
13
insert into student values ('t1', 'jhon', 20, 'cs'), ('t2', 'mike', 21, 'cs'), ('t3', 'jack', 22, 'ece');
 insert into regu values ('t1', 'jhon', 17), ('t2', 'jhon', 19), ('t3', 'mike', 21), ('t4', 'jack', 15), ('t5', 'jack', 19);