i have a list → 1:A,2:A,4:A,7:A,3:C,5:C,6:C,8:C,9:C,10:B,
i want to insert them into my database.
below is my database structure
my database after i insert the list into my database
i have no idea how to do this,i need help and guides ,thank you.
r937
2
strongly urge you to change your table, so that there is only one question/answer per row
CREATE TABLE answers
( question_no INTEGER NOT NULL PRIMARY KEY
, answer CHAR(9) NOT NULL
);
INSERT INTO answers VALUES
( 1 , 'A' )
,( 2 , 'A' )
,( 3 , 'C' )
,( 4 , 'A' )
,( 5 , 'C' )
,( 6 , 'C' )
,( 7 , 'A' )
,( 8 , 'C' )
,( 9 , 'C' )
,(10 , 'B' )
;
system
Closed
3
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.