Sequential Numbers for Database ID


Hi there,

I'm currently working on a node-red project in which I'm displaying data from an SQLite database. For various tables, I want to have a unique ID for each entry. Is there a way to incorporate a sequential number generator into the function that'll be pulling the data from the database?




In the sqlite docs lookup autoincrement, or google it.

1 Like