| Subject | RE: [firebird-support] Multiple values in a single INSERT query example |
|---|---|
| Author | Sasha Matijasic |
| Post date | 2008-01-11T13:03:09Z |
>Yes
> How to insert multiple values with a single insert statement?
> for example
>
> "INSERT INTO beautiful (name, age)
> VALUES
> ('Helen', 24),
> ('Katrina', 21),
> ('Samia', 22),
> ('Hui Ling', 25),
> ('Yumie', 29)"
>
> Is it possible in firebird?
insert into beautiful(name, age)
select 'Helen', 24 from rdb$database union all
select 'Katrina', 21 from rdb$database
... ;
Sasha