Hello,
I'm working on a project that will be inserting very large text streams into a
database. They range from 100K to 100M. I suspect that the average will be
about 2M per insert. This is a low volume (under 20 inserts per day). I don't
really need to optimize much on this but I had a
Michael,
Thanks. Thats what I was looking for, I just couldn't remember what it was.
Gary
From: Michael Dykman [mdyk...@gmail.com]
Sent: Wednesday, May 20, 2009 9:17 AM
To: Gary Smith
Cc: mysql@lists.mysql.com
Subject: Re: Large insert question
On Wed
On Wed, May 20, 2009 at 12:02 PM, Gary Smith g...@primeexalia.com wrote:
Hello,
I'm working on a project that will be inserting very large text streams into
a database. They range from 100K to 100M. I suspect that the average will
be about 2M per insert. This is a low volume (under 20
Is there a way to insert several rows into a table with one statement?
I have this:
$sql2 = INSERT INTO authors
(first_name, last_name, ordinal) VALUES
('$first_nameIN', '$last_nameIN', '1');
$result2 = mysql_query($sql2, $db);
I want to avoid doing another insert
On Tue, Feb 24, 2009 at 8:53 PM, PJ af.gour...@videotron.ca wrote:
Is there a way to insert several rows into a table with one statement?
I have this:
$sql2 = INSERT INTO authors
(first_name, last_name, ordinal) VALUES
('$first_nameIN', '$last_nameIN', '1');
Hi list,
I've got a small MyISAM table which is used for some statistics.
I'm only doing insert into this table.
I need that clients doing INSERT queries can exit as soon as possible.
So, i'm using INSERT DELAYED with some good succes.
But I've got a question.
If i decrease delayed_insert_limit
On Tue, Dec 09, 2003 at 12:17:41PM +0100, David Bordas wrote:
So, i'm using INSERT DELAYED with some good succes.
But I've got a question.
If i decrease delayed_insert_limit to ten secondes for example, is that mean
that delayed_queue will be flushed every ten secondes ?
Is there an other
So, i'm using INSERT DELAYED with some good succes.
But I've got a question.
If i decrease delayed_insert_limit to ten secondes for example, is that
mean
that delayed_queue will be flushed every ten secondes ?
Is there an other variable that specify the flush time ?
No -
On Tue, Dec 09, 2003 at 02:18:58PM +0100, David Bordas wrote:
I've read mysql doc sereval times, but i can't find any varaible that
specify when the delayed queue was flushed.
Well, I suppose that's because there isn't one. The DELAYED thread
handles that by itself. You don't want it too
Tuesday, December 09, 2003 2:51 PM
Chris Elsworth wrote:
If you increase delayed_insert_limit then you're effectively giving
the DELAYED thread more preferencee to the table; it will write more
rows (once it can, ie there's a phase of time where there's no locks
on the table) in a batch,
I have an insert that I have to get to work from the following tables
here is my query:
Select distinct t1.id, t3.id, t2.id, g.description, g.price, g.qty,
g.comments from cp.Category t1, Gifts g, cp.Manufacturer t2, cp.Pattern
t3 where t1.name = g.Category and t2.name = g.Manfacturer and
You need to substitute t1_id, t3_id ... etc, for the appropriate field
names in the
other_table you are wanting to insert the values into.
The missing fields will be filled in with their default values:
INSERT INTO other_table (t1_id, t3_id, t2_id, g_description, g_price,
g_qty, g_comments)
Hello All,
First, Let me start by saying this question has most likely been asked
before, but I did a search in the archive and was unable to come up with
any results. I think this is because I am not quite sure what this is
called. So, I do apologize, but hopefully this can be answered
PROTECTED]
Subject: very newbie insert question
This is my first script, so I am sorry it is so newbie-ish.
I think I have the correct script to open the connection, open the database
and the table. However, I cannot get the insert into to work. I have read
several online sources and books, all
newbie insert question
One only needs to specify the column names if and only if there are not
values, in the correct order, for all of the columns in the table.
That is:
Create Table foo (
aid intnot null auto_increment primary key
This is my first script, so I am sorry it is so newbie-ish.
I think I have the correct script to open the connection, open the database
and the table. However, I cannot get the insert into to work. I have read
several online sources and books, all of which are slightly different. It is
not a
it up so the email_address field is the primary key?
HTH.
--Russell
- Original Message -
From: sjs [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, October 03, 2001 7:51 PM
Subject: very newbie insert question
This is my first script, so I am sorry it is so newbie-ish.
I
]
To: sjs [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 03, 2001 7:53 PM
Subject: Re: very newbie insert question
I did not see the full schema so I can't give you a definite answer.
However, your syntax is wrong:
INSERT INTO email_addresses (last_name, first_name, email_address
Hello,
i'm writing an application in java and i have the following problem :
when i insert a record into a mysql table through the executeUpdate() method
of either Statement or PreparedStatement, does the method return immediately
or does it wait until MySql has the data written into the
Hi-o! I was wondering if it's possible when inserting a value into a table
that has an auto_increment field to have MySQL return the value of the
auto_increment field right after doing the insert, w/out having to run a
seperate query?
For example if I had a table with two collums, ID and name.
To: [EMAIL PROTECTED]
Subject: INSERT question...
Hi-o! I was wondering if it's possible when inserting a value into a table
that has an auto_increment field to have MySQL return the value of the
auto_increment field right after doing the insert, w/out having to run a
seperate query?
For example if I
21 matches
Mail list logo
