sequences of records

[iffoiffy]

Hi,

I have a table with primary key name "product_id" with values for primary

snp1
snp2
snp3
...
snp12


Using phpadmin when i insert a record last record inserted comes at the the last (bottom)


I have another table with same primary key name

but when i insert a record (snp12) something like this happens

snp1
snp12
snp2
snp4
snp5

snp12 instead of going at the end gets inserted after snp1

I don't know why?

Thanks

 

[r937]

because there is no sequence to rows in a table

there is no "first row" or "last row"

there are just rows

the only time you will get the sequence you want is with ORDER BY in a query

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[iffoiffy]

thanks, I want the record I enter at the last to appear at te top when I do query. Even if i do "order by product_id desc"


snp9 comes before snp12
I think i will have to add one timestamp field only then

I can have last record apprear at the top.

 

[nego78]

But think about creating a integer field with autoincrement and put primary index on it

or you can try to trick the query with LPAD and SUBSTRING

gry online

 

[iffoiffy]

i think I will create auto ,but still maintain primary key as product_id.

table already has data in it if I add auto field, it will not case any problem right?

 

[nego78]

you can have only autoincrement at filed which is a integer type and has primary key



gry online