MySQL Forums
Forum List  »  Newbie

Re: Insert record at a specified position
Posted by: Felix Geerinckx
Date: May 18, 2005 12:51AM

Utkal Ranjan wrote:

> I want to insert a new record at a specified posion in the existing table having some records
> Suppose I hvae 5 records and I want to insert a new record at position 3. How can I do that in
> MYSQL . I'm using version 4.

The rows in relational tables are by definition unordered. If you want to impose a certain ordering of your rows, you will have to retrieve them using an ORDER BY clause.

Perhaps you can give some more information about the problem you want to solve?

--
felix
Please use BBCode to format your messages in this forum.

Options: ReplyQuote


Subject
Written By
Posted
Re: Insert record at a specified position
May 18, 2005 12:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.