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