On 11/3/05, Paul Benedict <[EMAIL PROTECTED]> wrote: > Yes, > > SQL has a notation to INSERT multiple entries at once. > What you want to do is build a statement like the > following: > > INSERT INTO fruit (id, name) VALUES (0, 'Pear'), (1, > 'Apple'), (2, 'Peach')
Is that standard ANSI SQL? I know MySql supports that syntax, but wasn't aware that many (any?) others did. -- I tend to view "truly flexible" by another term: "Make everything equally hard". -- DHH
