Re: INSERT statement

Scott Mebberson wrote: > Is there any way to control where the a new row is added to a table. Its hard for newcomers to databases to understand, but you _don't_ insert rows of data into specific places in a table. You put all the information you need for getting the data out later into a column (or more than one). That is to say, if you need to get data out in a specific (arbitrary) order, add a numbered field to each row. When you insert data, you may have to re-number all the rows that come after the one you're inserting to. You need to think in terms of why you want data in a certain order. If you're concerned about data being in the order it was inserted, use a timestamp field. If you want data in alphabetical order, use "order by LastName" or the like when selecting your data. For example: SELECT FirstName, LastName, Age, City WHERE Age < 5 ORDER BY LastName,FirstName GROUP BY City. It doesn't matter in what order the data is in the table ... and it never should.