Re: Deleting & inserting problem

From: kirtan <kirtan.acharya_at_gmail.com>
Date: 1 Feb 2005 22:43:13 -0800
Message-ID: <1107326593.363399.300850@z14g2000cwz.googlegroups.com>

The rough definition of a relational database is that it is a collection of unordered tables. i.e the order of the rows in the table does not matter.

You can always use the ORDER BY clause to set the order of the rows in the way you want

Guru wrote:
> Hi All
>
> I have a scenario like this... Suppose
>
>
> Table A Contains
>
> colA
> ------
> AA
> BB
>
>
> suppose i delete the record AA.. and inserting record CC its
> displaying like this
>
> Table A Contains
>
> colA
> ------
> BB
> CC
>
>
> Actually i want like this
>
> Table A Contains
>
> colA
> ------
> CC
> BB
>
> I want to insert the record in the deleted col.I know we can update
> it.. But the scenario is like this..
> Warm Regards
> Guru
Received on Wed Feb 02 2005 - 00:43:13 CST