Re: INSERT INTO foo () VALUES ()

[prev] [thread] [next] [Date index for 2004/05/25]

From: Simon Cozens
Subject: Re: INSERT INTO foo () VALUES ()
Date: 14:35 on 25 May 2004

Tony Bowden:
> On Tue, May 25, 2004 at 02:55:56PM +0100, Simon Cozens wrote:
> > This works fine on MySQL, but bombs out on SQLite, because "INSERT INTO foo ()
> > VALUES ()" is arguably not great SQL. I've hacked around it by adding a dummy
> > column, but is this something that should and can be fixed in CDBI?
> 
> What should the SQL be in SQLite?

Painfully, "INSERT INTO foo VALUES (NULL)"

        -- 
        When an archer misses the mark, he turns and looks for the fault within
himself. Failure to hit the bull's eye is never the fault of the target. 
To improve your aim, improve yourself.
    -- Gilbert Arland

INSERT INTO foo () VALUES ()
Simon Cozens 13:55 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
Tony Bowden 14:13 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
Simon Cozens 14:35 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
Tony Bowden 14:37 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
ed-cdbi 14:42 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
Simon Cozens 14:49 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
ed-cdbi 15:13 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
cees-cdbi 15:47 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
Branislav Zahradnik 16:20 on 25 May 2004

RE: INSERT INTO foo () VALUES ()
"g 06:00 on 26 May 2004

Re: INSERT INTO foo () VALUES ()
Edward J. Sabol 14:40 on 26 May 2004