Re: INSERT INTO foo () VALUES ()

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

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

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?

Tony

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