Posted by Drazen Gemic on 03/29/07 16:29

On Mar 28, 3:50 pm, bill <nob...@spamcop.net> wrote:
> In other databases I have worked with this is a major pain
> because as soon as you save a record the order may change.
> OTOH, in mysql it appears that if you do a select for the whole
> table you have them all in memory and can change the value of the
> field "order" without having to worry about getting that record
> again and then save the whole table.

I am working on similar application, where I have steps in a certain
business process, but I don't use order number as a primary key.

I don't think that you shoud rely on such MySQL feature,
because it could change in next release.

My advice is to always repeat the query after renumbering.

DG

• Next in forum: Re: For loop and while loop. which one is faster?
• Prev in forum: Re: Using checkboxes to update multiple database entries
• Thread view: Re: Updating the SQL key value

[Reply to this message]