when a table doesn’t have unique ids but you need ’em

Every table in SQLite comes with a “rowid”. You just need to set that rowid into an actual column.

ALTER TABLE ep_2017 ADD ep_id  

UPDATE ep_2017 SET ep_id = rowid
Advertisements
when a table doesn’t have unique ids but you need ’em