Hi, I'd love some assistance with a custom SQL I'm looking to create a SQL for my primary key that starts with four digits (0001) and increases by 1 every time a new row is created. Thanks for your help in advance.

Unique format for primary key that automaticy increases

Kabirdas April 11, 2023, 11:14pm 2

Would you be open to using something like the solution mentioned here? Otherwise, curious to know what kind of SQL you're using

Topic		Replies	Views
Generate number in sequence 💬 Queries and Resources	5	1566	February 15, 2024
Trying to create an ID column and autoincrement each additional row created with Google Sheets 💬 Queries and Resources	3	3692	June 10, 2024
How to auto generate number with letter like PO001 if a value is empty? 💬 App Building	12	2285	August 3, 2023
Auto-incrementing IDs in Retool Database 💬 Queries and Resources	4	2145	August 3, 2023
Auto-increment YY-XXX Project Number with Reset Each January 1st 💬 App Building javascript , mysql	5	2405	April 15, 2024