Re: [sqlite] auto_increment and not null

[Andrew Finkenstadt]

On 6/28/07, Bruno S. Oliveira <[EMAIL PROTECTED]> wrote:

Hi all,

Now I see the what's happening.
But what if I need to create a table with two primary keys and one
auto incremented (and I DO need that!)? Isn't this possible?

If by primary key you mean alternate (unique) key, then yes.


create table andy_loves_sqlite (
 pk integer not null primary key autoincrement,
 ak integer not null unique
);