eal performance, and experiment
with optimizations.
-Original Message-
From: Hal Vaughan [mailto:h...@halblog.com]
Sent: Monday, November 08, 2010 10:39 AM
To: mysql@lists.mysql.com
Subject: Re: Running Queries When INSERTing Data?
On Nov 8, 2010, at 1:23 PM, Gavin Towey wrote:
> I&
i.e., LIFO.
-Original Message-
From: Hal Vaughan [mailto:h...@halblog.com]
Sent: Monday, November 08, 2010 1:39 PM
To: mysql@lists.mysql.com
Subject: Re: Running Queries When INSERTing Data?
On Nov 8, 2010, at 1:23 PM, Gavin Towey wrote:
> I'm not sure I understand exactly what you mean, b
e system was running smoothly and that's a long gap with
no programming work!
Hal
>
> Regards,
> Gavin Towey
>
> -Original Message-
> From: Hal Vaughan [mailto:h...@halblog.com]
> Sent: Monday, November 08, 2010 10:18 AM
> To: mysql@lists.mysql.com
> Subj
[mailto:h...@halblog.com]
Sent: Monday, November 08, 2010 10:18 AM
To: mysql@lists.mysql.com
Subject: Running Queries When INSERTing Data?
I'm redesigning some software that's been in use since 2002. I'll be working
with databases that will start small and grow along the way.
In
I'm redesigning some software that's been in use since 2002. I'll be working
with databases that will start small and grow along the way.
In the old format, data would come to us in mega-big text files that had to be
parsed and manipulated and so on with Perl to remove crap and finally produc
;
To: "Octavian Rasnita" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, July 31, 2007 5:27 AM
Subject: Re: inserting data - speed
The most obvious is to make sure you are doing bulk inserts, which you
may already be doing.
MyISAM tables use table locking, so you usually can'
The most obvious is to make sure you are doing bulk inserts, which
you may already be doing.
MyISAM tables use table locking, so you usually can't insert while a
search is occurring. There are a few exceptions and v5 (5.1?) has
another option you can set so inserts are always added to the e
At 04:37 AM 7/30/2007, Octavian Rasnita wrote:
Hi,
I made 2 similar programs that insert data continuously in 2 similar
MyISAM tables, each one in its own table.
Both tables have the same data (3.5 million records), but one of the
tables is update much slower.
The slower table is also access
Hi,
I made 2 similar programs that insert data continuously in 2 similar MyISAM
tables, each one in its own table.
Both tables have the same data (3.5 million records), but one of the tables
is update much slower.
The slower table is also accessed by other programs for getting data from
it.
Could this be a 'register_globals' issue? (Check your php.ini file.)
Are you sure that the queries you're sending are correct? Is
mysql_query() returning any errors?
Some more information, please!
Seth
On Fri, 1 Oct 2004 23:35:09 -0500, tom miller <[EMAIL PROTECTED]> wrote:
> i'am not sure i
i'am not sure if this is related to suse 9.1 or what i'am beginning
with mysql and php
i'am running:
mysql 4.0.21-standard
suse9.1
kernel version 2.6.5-7.10b-default
php version 4.3.4 - default install
apache 2.0.49 - prefork
i created an "address book" using php and when i go thru and fill in
ED]
> Subject: Re: Inserting data into table1 should insert data
> into table2's FK ???
>
> "Paul Fine" <[EMAIL PROTECTED]> wrote:
> >
> > If I have two tables with the first table containing a
> field which is FK of
> > table 2, when I inse
"Paul Fine" <[EMAIL PROTECTED]> wrote:
>
> If I have two tables with the first table containing a field which is FK of
> table 2, when I insert a value into this field, should it not automagically
> insert a value into that PK in the second table?
>
No, it should not insert data in the child tab
Du
If I have two tables with the first table containing a field which is FK of
table 2, when I insert a value into this field, should it not automagically
insert a value into that PK in the second table?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
ctober 09, 2003 3:39 PM
> To: Dan Greene
> Subject: Re: FW: FW: When inserting data it insert 2 records
> one correct
> and one blank!
>
>
> Im lost, im new on php and mysql so i may be omitting some
> statements or
> logics i send you the entire script, its an lbi t
10:34 AM
> To: Dan Greene
> Subject: RE: When inserting data it insert 2 records one correct and one
> blank!
>
>
> Ok, here it is the full statement:
>
> $sql = "INSERT INTO llamadas
> (destinatario,fecha,hora,apellido,nombre,telefono,mail,receptor,mensaje)
> VALU
[EMAIL PROTECTED]>
active.com> cc:
Subject: FW: When inserting data
it insert 2 records one
sending on to list while I think... ;)
-Original Message-
From: Emilio Ruben Estevez [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:34 AM
To: Dan Greene
Subject: RE: When inserting data it insert 2 records one correct and one
blank!
Ok, here it is the full statement
ilto:[EMAIL PROTECTED]
> Sent: Thursday, October 09, 2003 10:02 AM
> To: [EMAIL PROTECTED]
> Subject: When inserting data it insert 2 records one correct and one
> blank!
>
>
> Hi, I have a page on a intranet where workers can insert data into a
> database, the thing is th
Hi, I have a page on a intranet where workers can insert data into a
database, the thing is that when they type the info an press submit the page
use the INSERT INTO db then when i check the data in the database i can
see the record that the user entered and a second record that is all in
e things and goes against the
> concepts of normalized data.
>
> Edward Dudlik
> Becoming Digital
> www.becomingdigital.com
>
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Becoming Digital" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROT
ital.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Becoming Digital" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 15:59
Subject: Re: Inserting data?
I'd be glad to share.. you mean what the db is supposed to be? Ok,
th
ne, 2003 03:17
Subject: Inserting data?
I have a table, in the table is a field called name_id; in a second
table (a linking table) I also have the field name_id, this should be
the same/reference the same name_id as in the first table.
The first table is fully populated. How do write a SQL statemen
3:17
Subject: Inserting data?
I have a table, in the table is a field called name_id; in a second
table (a linking table) I also have the field name_id, this should be
the same/reference the same name_id as in the first table.
The first table is fully populated. How do write a SQL statement to
I have a table, in the table is a field called name_id; in a second
table (a linking table) I also have the field name_id, this should be
the same/reference the same name_id as in the first table.
The first table is fully populated. How do write a SQL statement to
get the data from the name_i
>Description:
For some reason the numeric fields in the middle ('sessionfid', 'ipfid') are not
putting values in there even though
it says it went through fine.
mysql> DESC phpss_log;
++--+---+--+-+-++
| Field
Octavian Rasnita wrote:
Could you tell me if the following script is OK?
Note: It uses DBD::mysqlPP and not DBD::mysql, because only this module can
be used under Perl 5.8, but it should work the same.
I'm using DBD::mysql under PERL 5.8 right now ... FYI.
--
Michael T. Babcock
C.T.O., Fib
Hello all,
I'm trying to get a table from a text file with columns delimited by the "|"
sign and I can't do it right.
I've made a perl script that gets the file, parses it, and inserts the
variables into the table, but the problem is that the text contains
characters like " ' ?
I've tried using
-Original Message-
From: Venu [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 12:29 PM
To: K. Satish Kumar
Subject: RE: Inserting data...
Hi,
> -Original Message-
> From: K. Satish Kumar [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 06, 2001
gt;
Sent: Saturday, November 17, 2001 3:25 AM
Subject: Re: Inserting Data on top
> Hello Sandeep!
>
> > I am trying to insert data from a form which has 4 fields such that the
data
> > always sits at the top in my database occupying locations :
> >
> > SEC_ID: 1, 2 , 3
INSERT always places data at the "end" of the table. SQL makes no assumptions
about the ordering of data. If you specify no order, you get "arrival
sequence", being the order the data was written to the table. If you want to
see the data in a certain order, you must order it with the ORDER BY clau
Hello Sandeep!
> I am trying to insert data from a form which has 4 fields such that the data
> always sits at the top in my database occupying locations :
>
> SEC_ID: 1, 2 , 3 & 4
>
> Everytime i insert data the data gets appended at the end i,e, if the first
> 4 fields are occupied my data tak
Hi all,
I am trying to insert data from a form which has 4 fields such that the data
always sits at the top in my database occupying locations :
SEC_ID: 1, 2 , 3 & 4
Everytime i insert data the data gets appended at the end i,e, if the first
4 fields are occupied my data takes the postions 5,6
So sprach Dave Carter am Fri, May 25, 2001 at 06:21:08PM -0400:
> Is there a way inside of mysql to force the case of data being inserted into
> the database???
-> http://www.mysql.com/doc/S/t/String_functions.html
LOWER() / LCASE() and UPPER() / UCASE()
Alexander Skwar
--
How to quote: htt
Is there a way inside of mysql to force the case of data being inserted into
the database???
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
-
Before posting, please chec
trick
-Original Message-
From: Peter Skipworth [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 11:47 AM
To: Fates
Cc: [EMAIL PROTECTED]
Subject: Re: Inserting data to multiple table at once
mySQL requires one insert command per
table. Stop being lazy, *grin*
P
On Wed, 18 Apr 2001, Fates
mySQL requires one insert command per
table. Stop being lazy, *grin*
P
On Wed, 18 Apr 2001, Fates wrote:
> How do I insert data into multiple tables without having to use multiple
>
>insert statements? Can I just do Insert into table1 (data) table2
> (data)
>table3 (data) or do I h
How do I insert data into multiple tables without having to use multiple
insert statements? Can I just do Insert into table1 (data) table2
(data)
table3 (data) or do I have to use seperate INSERT statements for each
table? I would like to add all at once from web page form
$query = "I
38 matches
Mail list logo