Re: How does a multi-row INSERT work?

2005-04-01 Thread Gabriel PREDA
); update index close table open table INSERT INTO x VALUES (c,d); update index close table But for INSERT INTO x VALUES (a,b),(c,d); The server does: open table INSERT INTO x VALUES (a,b),(c,d); update index close table Now it's clear why multi-row I

Re: How does a multi-row INSERT work?

2005-03-31 Thread Rhino
There are two forms of multi-row insert. Here is a script that illustrates both: use tmp; drop table if exists target; create table if not exists target (id smallint not null, name char(10) not null

Re: How does a multi-row INSERT work?

2005-03-31 Thread beacker
Chris W. Parker writes: >I searched the archives, looked through the manual, and searched google >for info on how to actually perform a multi-row INSERT but didn't find >an answer. The basic syntax is to separate the (...) with commas (,) ala: create table table1 (sku int, tit

Re: How does a multi-row INSERT work?

2005-03-31 Thread SGreen
Dan Nelson <[EMAIL PROTECTED]> wrote on 03/31/2005 03:01:45 PM: > In the last episode (Mar 31), Chris W. Parker said: > > I searched the archives, looked through the manual, and searched > > google for info on how to actually perform a multi-row INSERT but >

RE: How does a multi-row INSERT work?

2005-03-31 Thread Chris W. Parker
John McCaskey on Thursday, March 31, 2005 12:04 PM said: > This is documented on the INSERT Syntax page of the manual, but it may > be kind of hard to read for a beginner as it just says VALUES({expr | > DEFAULT},...),(...),... Oooh... In fact I did look through tho

Re: How does a multi-row INSERT work?

2005-03-31 Thread John McCaskey
VALUES({expr | DEFAULT},...),(...),... On Thu, 2005-03-31 at 11:46 -0800, Chris W. Parker wrote: > Hello, > > I searched the archives, looked through the manual, and searched google > for info on how to actually perform a multi-row INSERT but didn't find > an answer. > > Wo

Re: How does a multi-row INSERT work?

2005-03-31 Thread Dan Nelson
In the last episode (Mar 31), Chris W. Parker said: > I searched the archives, looked through the manual, and searched > google for info on how to actually perform a multi-row INSERT but > didn't find an answer. > > Would someone please show me the syntax for this please? &g

Re: How does a multi-row INSERT work?

2005-03-31 Thread Jonathan Wright
Chris W. Parker wrote: Hello, I searched the archives, looked through the manual, and searched google for info on how to actually perform a multi-row INSERT but didn't find an answer. Would someone please show me the syntax for this please? I could just do a loop and INSERT the data that wa

How does a multi-row INSERT work?

2005-03-31 Thread Chris W. Parker
Hello, I searched the archives, looked through the manual, and searched google for info on how to actually perform a multi-row INSERT but didn't find an answer. Would someone please show me the syntax for this please? I could just do a loop and INSERT the data that way but according t

Re: Multi-row insert

2002-09-20 Thread Chris Tucker
is Tucker wrote: > > > I'm having some trouble with a sizable (but certainly not huge) > > multi-row insert statement. I can successfully execute the query with > > up to 7365 rows, but any more and it fails > -- > Brent Baisley > Systems Architect > Land

Re: Multi-row insert

2002-09-20 Thread Brent Baisley
May 30 14:51:26 PDT 2002; root:xnu/xnu-201.42.3.obj~1/RELEASE_PPC Power Macintosh powerpc Distro: MacOS 10.1.5 MySQL version: 3.23.51 On Thursday, September 19, 2002, at 06:55 PM, Chris Tucker wrote: > I'm having some trouble with a sizable (but certainly not huge) > multi-ro

re: Multi-row insert

2002-09-20 Thread Egor Egorov
Chris, Friday, September 20, 2002, 1:55:39 AM, you wrote: CT> I'm having some trouble with a sizable (but certainly not huge) CT> multi-row insert statement. I can successfully execute the query with CT> up to 7365 rows, but any more and it fails (ERROR 2006: MySQL server has

Multi-row insert

2002-09-19 Thread Chris Tucker
Hi, I'm having some trouble with a sizable (but certainly not huge) multi-row insert statement. I can successfully execute the query with up to 7365 rows, but any more and it fails (ERROR 2006: MySQL server has gone away). More complete info: Total working query size: 1047426

Re: Multi-Row Insert

2001-10-02 Thread alec . cawley
> Is there any way to insert more than one row at a time??? The data that I > have will change with each row, but is there a way to insert 900 rows (with > different values for each) all at once? INSERT INTI VALUES (row1), (row 2), (row3) . where rowN is a list of values for the row in

Multi-Row Insert

2001-10-02 Thread Solsberry, Glendon
Is there any way to insert more than one row at a time??? The data that I have will change with each row, but is there a way to insert 900 rows (with different values for each) all at once? database,sql,query,table PS The listserv is starting to piss me off... Must have one of the keywords, no