SQLTeam.com | Weblogs | Forums

Custom row via sql query insert into when value changes

I have MySQL database. I insert some records/questions in it via insert into statement. I run 6 different SQL queries to insert questions of 1,2,3,4,5,6 marks from the master table to tmp table one after the other.

The Problem: I want to insert a custom row before starting and next to every mark change row.

This row will contain two variables one is for the section and one is for the mark. These will change accordingly (basically these are headings of the sections).

Well! it is not essential that we will have questions of all marks like 1,2,3,4,5,6 so section variable and mark variable will change accordingly via SQL


query.

Sections will always be sequential: Section-A, Section-B, Section-C