How can I create a view with an identity column!

[ploiesti]

Hello!
How can I create a view with an identity_insert column(or something like that) ...(I want that in column named "id" to have 1,2,3,... count(row from the view))! How can I do that! Thanks! I want to use that in a query like this:
"Select * from my_view_table where id>$id_1 and id<$id_2" where $id.. are php variabiles!
The "my_view_table" will have ~1.000.000 row, with 43 columns!
Thanks!

[bad76]

Hi!
If you don't have any into your db you can do two way!

First! add a column to your db!Set it to int(8) autoinc!

Second! Use "LIMIT start, count" instead "where min<id<max"!

Your "Select from my_view_table where id>$id_1 and id<$id_2"
is now "Select from my_view_table LIMIT $id_1,".($id_2-$id_1) !

I hope this helps you!