Hi, Steven and christopher,
Thanks a lot for your help.
I think i have to store the question number in table.
my talbe questionbank store the questions related more
than one course. every course has six question sets.
so i use question set id and question number as
primary key. There is one probl
On Fri, 2002-04-12 at 13:52, Christopher Thompson wrote:
> You shouldn't be storing the questio number at all. You have denormalised
> your database and this is why you are experiencing this problem.
Maybe I don't understand bin's problem, but storing the question #
wouldn't seem to be de-norma
You shouldn't be storing the questio number at all. You have denormalised
your database and this is why you are experiencing this problem.
Instead, store a unique identifier with each one (an 'id' field,
autonumbering) and then, when you pull back all the questions, order it by
this ID field.
Hello, verybody,
I am afraid to send my question again.
i created a table in mysql database system to store
exam questions which has the following column fields:
questionnumber(integer),questionbody(String), answers
(String) and etc.
My problem is if i delete one row(question record) how
can iup
