Re: [sqlite] How do I write this query

2013-04-29 Thread James K. Lowden
On Mon, 29 Apr 2013 16:14:00 -0500 "Michael Black" wrote: > sqlite> CREATE TABLE foo( a integer, b integer); > sqlite> INSERT INTO foo VALUES(1,1); > sqlite> INSERT INTO foo VALUES(1,2); > sqlite> INSERT INTO foo VALUES(1,3); With 3.7.13 at least, insert into foo values (1,1),(1,2),(1,

Re: [sqlite] How do I write this query

2013-04-29 Thread Igor Korot
2|2|1 > 2|3|1 > > Mike > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Korot > Sent: Monday, April 29, 2013 4:06 PM > To: General Discussion of SQLite Database > Subject: [sqlite] How do I

Re: [sqlite] How do I write this query

2013-04-29 Thread Michael Black
Igor Korot Sent: Monday, April 29, 2013 4:06 PM To: General Discussion of SQLite Database Subject: [sqlite] How do I write this query Hi, ALL, CREATE TABLE foo( a integer, b integer); INSERT INTO foo VALUES( 1,1); INSERT INTO foo VALUES( 1,2); INSERT INTO foo VALUES( 1,3); INSERT INTO foo VALUES

Re: [sqlite] How do I write this query

2013-04-29 Thread markus diersbock
Why are basic SQL questions being asked in the SQLite forum? On Mon, Apr 29, 2013 at 5:06 PM, Igor Korot wrote: > Hi, ALL, > > CREATE TABLE foo( a integer, b integer); > INSERT INTO foo VALUES( 1,1); > INSERT INTO foo VALUES( 1,2); > INSERT INTO foo VALUES( 1,3); > INSERT INTO foo VALUES( 2,1);

[sqlite] How do I write this query

2013-04-29 Thread Igor Korot
Hi, ALL, CREATE TABLE foo( a integer, b integer); INSERT INTO foo VALUES( 1,1); INSERT INTO foo VALUES( 1,2); INSERT INTO foo VALUES( 1,3); INSERT INTO foo VALUES( 2,1); INSERT INTO foo VALUES( 2,2); INSERT INTO foo VALUES( 2,3); CREATE TABLE bar( a integer, b integer, c integer); INSERT INTO ba