:auto-increment support for SQLite databases ?
Tim Showalter <tjs-8WfoLeasP/[email protected]> Thu, 03 Feb 2011 00:03:49 -0800
| Newsgroups | gmane.lisp.clsql.general |
|---|---|
| Message-ID | <[email protected]> |
Hi, I have a suggestion, but I'm not quite sure how to implement it. I see :auto-increment works for MySQL databases only. Is there any chance it can be added for SQLite databases as well? Unfortunately, the SQL query has to be SELECT LAST_INSERT_ROWID() instead of LAST_INSERT_ID(). I don't quite see the right way to do this, but just hacking the query in oodml.lisp appears to work. Thanks very much, Tim