It trumps even the primary key that I've defined. I could, for example, update the previous example of selecting the Hens table and request both the Id and the rowid, as follows: s.prepare(c, "select ...

MySQL table primary keys and unique indexes prevent multiple rows with the same index from being added to the table. If you try to insert a duplicate row with a standard INSERT statement, you will ...