Have a look at the Merge engine.
On Sun, Oct 18, 2009 at 10:31 PM, Allen Fowler allen.fow...@yahoo.comwrote:
Hello,
I have a Python application that is using MySQL to store records of
transactions about 3 tables with ~1k records each.
How can I periodically copy the records off the
dear all, a novice here
quickie regarding query syntax - is it possible to take fields values
from one column
and update the same column with new values like this: prefix_OldValue
column: one, two, three - column: prefix_one, prefix_two, ...
can this be done with one query and with on use of
Something in the ilk of
update *table* set *field* = concat(prefix_, *field*) where *condition *
should do the trick.
On Mon, Oct 19, 2009 at 4:56 PM, lejeczek pelj...@yahoo.co.uk wrote:
dear all, a novice here
quickie regarding query syntax - is it possible to take fields values from
one
At 05:40 AM 10/18/2009, John wrote:
Mike,
What behaviour you experience depends to some extent on what storage engine
you are using and on what other non-unique indexes you have on the tables.
With LOAD DATA INFILE on empty MyISAM tables all non-unique indexes are
created in a separate batch
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
-Original Message-
From: Scott Haneda [mailto:talkli...@newgeo.com]
Sent: Friday, October 16, 2009 2:44 PM
To: Jerry
Dear all,
Benetl, a free ETL tool for files using MySQL, is out in version 3.2.
This new version is now supporting Java SE 6 and using memory arguments
for JVM.
You can freely download it at : www.benetl.net
You can learn more about ETL tools at:
I have a problem with MySQL passwords... I set them, write them down...
and they stop working. I have to go in and manually reset them.
Right now, I have a database that, even after resetting the password, I
still cannot access it.
/var/log/mysql.log doesn't give me any useful information. How
The type of password instability you are talking about is pretty much
unheard of in MySQL.. however, reverse DNS resolution is always
messing up depending on the network setup. From a console on your
database host, how easily can you resolve the hostnames that your
client is presenting? What is
On Mon, 19 Oct 2009 16:30:47 -0700
John Oliver joli...@john-oliver.net wrote:
I have a problem with MySQL passwords... I set them, write them
down... and they stop working. I have to go in and manually reset
them.
Right now, I have a database that, even after resetting the password,
I
someone probably installed mysql for DHCP address e.g 192.168.fu.bar
then as luck would have it the IP address changed
if you pull all network connections everyone on that box should be able to
access mysql
Salutations de l'état du chômage
Martin Gainty
10 matches
Mail list logo