Updating multiple rows in sql

The only thing I am trying to solve is updating the database with one query instead of (1 to N) number of insert queries depending on how many "items" are listed.

- The database must contain a record of answers made by all users- Every "Item" has 4 answers associated with them, (for now...)- There can be any number of "items" listed on a single survey page (in this screenshot, I only show 3 items, but there may be up to 20 or 30 items that have to be listed)- "Value Saved" has a HIDDEN constant that gets calculated with the "Test Value" entered.

In this article I will show you the most common methods of using the UPDATE statement.

updating multiple rows in sql-51updating multiple rows in sql-55updating multiple rows in sql-37updating multiple rows in sql-56

For all helpful answers below, show this by clicking on the thumbs up next to those answers.

The problem I find with that structure is there are at the same time an variable number of questions and an variable number of answers plus multiple answers for a single individual that need to be recorded. Unfortunately, I was tasked to present the survey in the format shown in the screenshot below, which is why I chose to design the table structures the way I did.

Thing is, there have been no concerns about normalization as I have had no problems with data insertion, querying results, reporting the answers, association of answers with members, etc!

;) table_foobar ( foobar_id, member_id, question_id, answer One, answer Two, answer Three, answer Four ) //Multiple questions for a single foobar Main survey.

tbl_foobar Question ( question_id, foobar Main_id, foobar Question ) tbl_foobar Main ( foobar Main_id, foobar Name, foobar Description ) your database is not normalised as was mentioned before.

Leave a Reply

  1. mars venus dating book 16-Mar-2017 15:39

    First comes love, then comes marriage, then comes a baby and a hit reality TV show on E!

  2. Late night mature chat 14-Mar-2018 12:40

    Affleck's Oscar campaign had been dogged by two 2010 civil suits involving allegations of sexual harassment, both of which were later settled.

  3. baggage dating decide divorced hes if man right sort through 28-Oct-2017 19:45

    Its high rate of subscribers engaging in romantic relationships and meeting live partners makes it a one-stop dating site.

  4. forms of dating objects 22-Aug-2017 04:11

    red oasis dating is a premium online dating site catering for mature dating, uniform dating and other types of online dating.

  5. Sri lankan online sex webcam 30-Apr-2017 23:09

    I was the "funny guy." Now in college, meeting women is much easier, but I couldn't help but feel insecure about my lack of experience so I figured a few decent flings would help.