Create table tbl_bm_questionInf(
id number primary key,
titleContent varchar(40) not null ,
rightAnswer varchar(20) not null,
type int ,
score varchar(40)
);
drop table tbl_bm_answerInf
drop table tbl_bm_questionInf
delete from tbl_bm_questionInfo;
Create table tbl_bm_answerInf(
id number primary key, --序号 答案序号ID
answerContent varchar(40) not null, --答案内容
answerid number references tbl_bm_questionInf(id),
type int --答案类型 1多选 2单选3简答
);
select tbl_bm_questionInf.id,tbl_bm_questionInf.titleContent,tbl_bm_questionInf.score,
tbl_bm_answerInf.answerContent
from tbl_bm_questionInf , tbl_bm_answerInf
where
tbl_bm_questionInf.id=tbl_bm_answerInf.answerid
group by tbl_bm_questionInf.id
id number primary key,
titleContent varchar(40) not null ,
rightAnswer varchar(20) not null,
type int ,
score varchar(40)
);
drop table tbl_bm_answerInf
drop table tbl_bm_questionInf
delete from tbl_bm_questionInfo;
Create table tbl_bm_answerInf(
id number primary key, --序号 答案序号ID
answerContent varchar(40) not null, --答案内容
answerid number references tbl_bm_questionInf(id),
type int --答案类型 1多选 2单选3简答
);
select tbl_bm_questionInf.id,tbl_bm_questionInf.titleContent,tbl_bm_questionInf.score,
tbl_bm_answerInf.answerContent
from tbl_bm_questionInf , tbl_bm_answerInf
where
tbl_bm_questionInf.id=tbl_bm_answerInf.answerid
group by tbl_bm_questionInf.id
你想问什么呢LZ