auto update number in mysql

2002-04-12 Thread bin cai
Hello, verybody, currently i got one question. i create a table in mysql database to store questions which have following column fields: questionnumber, questionbody, answers and etc. My problem is if i delete one row(question) how can i update the questionnumber in the easiest way which means

Re: auto update number in mysql

2002-04-12 Thread Kevin Stone
questionnumber field is being used for sorting purposes then I would suggest some sort of script (PHP, PERL or ASP) to control the value. -Kevin - Original Message - From: bin cai [EMAIL PROTECTED] To: mysql list [EMAIL PROTECTED] Sent: Friday, April 12, 2002 1:35 PM Subject: auto update number