MySQL Forums
Forum List  »  Newbie

Re: Multi rows
Posted by: Phillip Ward
Date: November 30, 2022 10:00AM

For each Person studying a course, you need a row in a table that represents this.
Calling this "Results" is a little odd, but assuming that this is the right table, you'd have something like this:

insert into Results values ( 1, 'Course 1', 0 ); 
insert into Results values ( 2, 'Course 1', 0 ); 
insert into Results values ( 3, 'Course 1', 0 );

Regards, Phill W.

Options: ReplyQuote

Written By
November 27, 2022 05:36AM
November 28, 2022 04:52AM
November 28, 2022 08:19AM
November 29, 2022 05:39AM
Re: Multi rows
November 30, 2022 10:00AM
December 06, 2022 01:32PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.