Re: Subselects and INSERT statements with McKoi

Hi Chris,

The following query will work as intended;

   INSERT INTO SKILLS (ID, NAME, DESCRIPTION)
     SELECT MAX(ID)+1, 'Java', 'Java programming' FROM SKILLS

Toby.

Christopher Brown wrote:

> Hi,
> 
> I tried the following query:
> 
> INSERT INTO SKILLS (ID, NAME, DESCRIPTION) VALUES ((SELECT MAX(ID)+1 FROM
> SKILLS), "Java", "Java programming");
> 
> ...on a table defined as:
> 
> CREATE TABLE IF NOT EXISTS SKILLS (
>  ID                     INTEGER       NOT NULL,
>  NAME                   VARCHAR(32)   NOT NULL,
>  DESCRIPTION            VARCHAR(4096) NOT NULL,
>  PRIMARY KEY (ID),
>  UNIQUE(NAME)
> );
> 
> McKoi DB's SQL parser rejects this query.  Is there any way I can perform
> something along those lines without triggers/sequences?
> 
> Thanks,
> Chris B



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]