Re: Insert Multiple Rows into a Table Without Using Select
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 29 Sep 2005 20:43:56 +0200
On Wed, 28 Sep 2005 13:22:02 -0700, RitaG wrote:
>Thanks Hugo for your response.
>I have 4 lines that I want to insert into a table in 30 databases.
>The column values are always the same for the 30 databases and I don't need
>a "Select" statement.
Hi Rita,
Well, you can either have 4 INSERT statements with a VALUES clause, or
one INSERT statement with a UNION'ed SELECT clause, as I wrote in my
previous reply. There are no other alternatives.
But I guess the real question is: why do you store the same data in 30
identical tables in 30 databases? Maybe it's time to get rid of some of
the redundancy?
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
.
- References:
- Re: Insert Multiple Rows into a Table Without Using Select
- From: Hugo Kornelis
- Re: Insert Multiple Rows into a Table Without Using Select
- Prev by Date: Re: Insert Multiple Rows into a Table Without Using Select
- Previous by thread: Re: Insert Multiple Rows into a Table Without Using Select
- Index(es):
Relevant Pages
|
