Delete a simple row in a database...

[albert]

I have a sql table in a database with diferent rows but at same time they are similar to each other...
something like this example
01/07/2007 alfa 200
01/07/2007 alfa 400
01/07/2007 beta 200

How can I delete a simple row without touch the others from the database?
It's there a easy way to identify every row in a database with a unique number?
Thanks !

 

[Erel]

You should use a primary key. See this page: http://www.sqlite.org/lang_createtable.html

 

[albert]

Thanks Erel
It works fine with the RowId !! :sign0060:

But when i delete a row ...i delete aswell de rowid for this row; How can I refresh the rowid for the existing rows (after I deleted one row)? :sign0104:

 

[Erel]

As a principal primary keys are unique, and a deleted key should not be used again.