SQLite Forum

Error: near "returning": syntax error
Login
Third-Mini% sqlite3\

SQLite version 3.35.2 2021-03-17 19:07:21\

Enter ".help" for usage hints.\

Connected to a transient in-memory database.\

Use ".open FILENAME" to reopen on a persistent database.\

sqlite> create table test(id integer primary key);\

sqlite> insert into test default values returning id;\

1\

sqlite> \

Third-Mini% \

What's yer problem?