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
O
On Wed, May 20, 2009 at 12:02 PM, Gary Smith 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 inserts per day).
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 qu
On Tue, Feb 24, 2009 at 8:53 PM, PJ 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')";
>$result2 = mysql_query(
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 lik
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, w
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 la
> > 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 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 o
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
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)
SELEC
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 t3.name
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 quick
[EMAIL PROTECTED]
> Subject: Re: very 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 (
>
, 2001 5:51 PM
To: [EMAIL 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
se
'$email');
..chris
- Original Message -
From: "Russell Miller" <[EMAIL PROTECTED]>
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
have to specify a column name.
Did you set 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 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 par
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 dat
2001 6:18 PM
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 que
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. Wh
21 matches
Mail list logo