Computing.Net > Forums > Database > inserting rows into table

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

inserting rows into table

Reply to Message Icon

Name: trichyselva
Date: April 18, 2006 at 03:25:37 Pacific
OS: windows xp
CPU/Ram: p4
Product: pentium
Comment:

suppose i have a table with 5 rows i want to insert 2 rows between existing 2nd and 3rd row, is it possible? if so, how to do it?



Sponsored Link
Ads by Google

Response Number 1
Name: SN
Date: April 18, 2006 at 09:20:31 Pacific
Reply:

In a database, the order in which the rows actually reside in the table should be irrelevant, so most databases don't have an easy way to do what you want.

Instead, you should consider using the ORDER BY part of the SELECT statement to retrieve the rows in the order you want, rather than storing them in the order you want.

Good luck,
-SN


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: inserting rows into table

insert into www.computing.net/answers/dbase/insert-into/202.html

SQL text search loop www.computing.net/answers/dbase/sql-text-search-loop/431.html

Entering Data into Table www.computing.net/answers/dbase/entering-data-into-table/584.html