Hi Mike,
On 11/8/2011 20:46, Mike Seda wrote:
All,
Can anyone out there explain the result of the third statement provided
below:
mysql select count(distinct field1) from db1.table1;
++
| count(distinct field1) |
++
| 1063 |
Hi,
mysql select count(distinct field1) from db2.table1 where field1 not in
(select field1 from db1.table1);
++
| count(distinct field1) |
++
If the field db1.table1.field1 has the same name that the field
db2.table1.field1, maybe you have
If you could use MyISAM tables then you could use Merge Tables and
create a table for each day (or whatever period you are collecting
data for). Then when it is time to get rid of the old data, drop the
oldest table (T2001 or T10 for 10 days ago) and create a new
empty table for the new
Rong,
On the server, we are using the following RPMs (from MySQL):
- MySQL-server-5.5.11-1.rhel5.x86_64
- MySQL-client-5.5.11-1.rhel5.x86_64
On the clients, we are using the following RPM (from Red Hat):
- mysql-5.0.45-7.el5.x86_64 RPM
Mike
On 11/09/2011 10:49 AM, Rong Chen wrote:
Javier,
Hello Reindi,
I don't mean to revisit an old post however, we are also using innodb
and experiencing a rough start.
Should we set innodb_file_per_table to 1? Also we expereince this
scenario a lot:
mysql show tables;
+---+
| Tables_in_symax |
Hi,
Recently a home server has crashed and would not boot anymore into
Windows. We decided to replace it altogether and I managed to repair the
file system more or less so that I could copy some directories from the
broken disk. One of them is the MySQL data directory of that XAMPP
installation.
Am 09.11.2011 21:46, schrieb Yves Goergen:
The old machine was an unknown MySQL version on Windows XP
pfff - unknown version? how comes?
The error log is attached to this mail. It all sounds like real bugs in
MySQL, at least it's standing in the file
there is no attachment
so please CLEAR
On 09.11.2011 21:58 CE(S)T, Reindl Harald wrote:
Am 09.11.2011 21:46, schrieb Yves Goergen:
The old machine was an unknown MySQL version on Windows XP
pfff - unknown version? how comes?
The old MySQL installation doesn't run anymore because the OS is gone. I
could only backup the files.
Hello Reindl, I just noticed that I misspelled your name. Sorry about that!
Cheers,
Nick.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Dear all,
Benetl, a free ETL tool for MySQL, is out in version 3.9.
This version is correcting two bugs in GUI and brings code improvement.
Benetl is freely dowloadable at: http://www.benetl.net
You can learn more about ETL tools at:
http://en.wikipedia.org/wiki/Extract,_transform,_load
10 matches
Mail list logo