On Thu, Sep 23, 2010 at 12:39 AM, Camilo Uribe camilo.ur...@gmail.comwrote:
On Fri, Jul 9, 2010 at 12:03 AM, Johan De Meersman vegiv...@tuxera.be
wrote:
This will mostly depend on your OS, really. Assuming you're running a
64-bit
flavour of *nix on that box, I don't think you have to
ALTER TABLE tablename1 CHANGE column1 column2 VARCHAR(64), CHANGE column2
column1 VARCHAR(64)
Assuming the columns are varchar(64)
Jangita | +254 76 918383 | MSN Y!: jang...@yahoo.com
Skype: jangita | GTalk: jangita.nyag...@gmail.com
-Original Message-
From: nixofortune
Hi all,
I've the following query :
SELECT fixtures_results.seasons_id ,
home_teams_id AS teams_id ,
1 AS home ,0 AS away ,
(SELECT SUM(goals) FROM players_appearances WHERE
fixtures_results.fixtures_results_id =
players_appearances.fixtures_results_id AND players_appearances.teams_id =
Hi Kevin,
It works in mysql but not exactly as I need.
In my case it copied content of column2 into column1.
So, not exactly what I intended to achieve.
Thanks.
Igor
update mydata set column1 = column2, column2 = column1
On Thu, Sep 23, 2010 at 12:03 AM, Kevin (Gmail) kfoneil...@gmail.comwrote:
I wondered if anyone can help me ? Do you need any further information ?
Cheers
Neil
-- Forwarded message --
From: Tompkins Neil neil.tompk...@googlemail.com
Date: Thu, Sep 23, 2010 at 9:49 AM
Subject: Query help please
To: [MySQL] mysql@lists.mysql.com
Hi all,
I've the
If this is a dedicated MySQL box, i would increase the InnoDB buffer pool
setting in my.cnf to at least 8GB, 12 would be even better (you did say you
have 16GB of ram in the machine I believe).
Also, what is the output of:
show status like '%tmp%';
JW
On Wed, Sep 22, 2010 at 8:01 PM, Vokern
On Thu, Sep 23, 2010 at 1:21 AM, Johan De Meersman vegiv...@tuxera.be wrote:
On Thu, Sep 23, 2010 at 12:39 AM, Camilo Uribe camilo.ur...@gmail.com
wrote:
On Fri, Jul 9, 2010 at 12:03 AM, Johan De Meersman vegiv...@tuxera.be
wrote:
This will mostly depend on your OS, really. Assuming you're
hi,everyone
i try to compile and install mysql from source tarball,but i failed
again again.
this is my config string:
[r...@powerpc mysql-5.5.6-rc]# ./configure --prefix=/usr/local/mysql
--exec-prefix=/usr/local --sysconfdir=/etc/sysconfig/mysql
--localstatedir=/var --enable-profiling