faqts : Computers : Databases : MySQL : Common Problems : Unusual Queries

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

23 of 29 people (79%) answered Yes
Recently 7 of 10 people (70%) answered Yes

Entry

Does every row in a MySQL table have a unique row ID?

May 18th, 2000 06:31
Nathan Wallace, Steve Ruby


No, there are no server-side cursors in MySQL, you have to have a where
statement on any delete statement that is not supposed to delete all the
data in the table.

There is no notion of ROW or posision in MySQL only lines referenced by
a unique key or primary key value or other values in the table.