Re: Insert Multiple Rows into a Table Without Using Select

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)
.

Relevant Pages