At 05:57 AM 11/5/2009, you wrote:
Hello, I am currently inserting about 10 rows (2 varchar 50 fields ) a sec
into modern 4 processor RH 5.x box using perl Net::Mysql from another box
of similar spec. This is rather less than expected. I suspect I
could push the inserts from the source box
Hi Charles,
the socket is created either in the default location or in the location
specified in the 'my.cnf' configuration file under the [mysqld] section,
you can have different 'my.cnf' files in the system in different default
locations that are read in a cascading style sheet fashion (for
Hello,
I am importing CSV data from a proprietary database into a table in MySQL. Due
to a flaw in the proprietary software's export tool, currency values (floats)
are always exported with a '$' prefixed to them. This causes a problem where
the matching float field in the MySQL table being
I think you can use update replace.
UPDATE table SET column=REPLACE(column,'$','');
Kyong
On Thu, Nov 5, 2009 at 1:35 PM, Tim Legg kc0...@yahoo.com wrote:
Hello,
I am importing CSV data from a proprietary database into a table in MySQL.
Due to a flaw in the proprietary software's export
Holy Crapoly!
SOLVED in 17 minutes That is a new record for me.
UPDATE `imported_data` SET `PartPrice`=REPLACE(`PartPrice`,'$','');
...accomplished my task.
I read the REPLACE page in section 12.2.7 of the online Reference Manual and
didn't see the utility of it. The REPLACE page there
Yeah. Sometimes the manual is lacking in practical examples.
Always good to try the list instead of just getting bogged down in the manual.
Kyong
On Thu, Nov 5, 2009 at 2:28 PM, Tim Legg kc0...@yahoo.com wrote:
Holy Crapoly!
SOLVED in 17 minutes That is a new record for me.
UPDATE
Is it recommended we disable connection pooling,
so that all connections are instantly closed ?
Frankly, no. Well-behaved connection pooling is a good thing. It
will reduce the load on your system resources and speed up responses
considerably.
If the only thing at issue is that you have