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?

Thanks.

In the sqlite docs lookup autoincrement, or google it.

1 Like