);
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 INSERT
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
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 way
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?
I could just do a loop
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.
Would someone please show me
John McCaskey mailto:[EMAIL PROTECTED]
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 those
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
didn't find an answer.
Would someone
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, title varchar (20
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
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
CT gone away). More
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-row insert statement. I can
)
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
Landover Associates, Inc.
Search Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
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 bytes
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,
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 table VALUES (row1), (row 2), (row3) .
where rowN is a list of values for the row
15 matches
Mail list logo