Hello,
Looking at the SQL syntax chart it doesn't seem like
this is possible. In other SQL servers I'm able to use the statement
"insert into foo('col1', col2') values ('1', '1'), ('2', '2'), ('3',
'3');". Is this possible in SQLite or must I instead insert one at a
time.
-Sh
On Tue, 28 Jul 2009 14:22:28 -0400, "Shaun Seckman
(Firaxis)" wrote:
>Hello,
>
>Looking at the SQL syntax chart it doesn't seem like
>this is possible. In other SQL servers I'm able to use the statement
>"insert into foo('col1', col2') values ('1', '1'), ('2', '2'), ('3',
>'3');"
}
return $numInserted;
}
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Shaun Seckman
(Firaxis)
Sent: Tuesday, July 28, 2009 2:22 PM
To: General Discussion of SQLite Database
Subject: [sqlite] Insert multipl
On Tue, 28 Jul 2009, Shaun Seckman (Firaxis) wrote:
> Looking at the SQL syntax chart it doesn't seem like this is possible.
> In other SQL servers I'm able to use the statement "insert into
> foo('col1', col2') values ('1', '1'), ('2', '2'), ('3', '3');". Is this
> possible in SQLite or must
return undef;
} else {
$errorMessage = undef;
}
return $numInserted;
}
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Shaun Seckman
(Firaxis)
Sent: Tuesday, July 28, 2009 2:22 PM
To: General Di
On 28 Jul 2009, at 7:22pm, Shaun Seckman (Firaxis) wrote:
>Looking at the SQL syntax chart it doesn't seem like
> this is possible. In other SQL servers I'm able to use the statement
> "insert into foo('col1', col2') values ('1', '1'), ('2', '2'), ('3',
> '3');". Is this possibl
Kees Nuyt wrote:
>
>
> Insert one row at a time.
>
>
>
Presumably you can do this kind of thing:
INSERT INTO Table2 ( [FieldX] )
SELECT FieldY
FROM Table1;
--
View this message in context:
http://www.nabble.com/Insert-multiple-entries-in-a-single-INSERT-statement-tp24705205p24737715.html
7 matches
Mail list logo