> Halaasz Saandor hat am 9. Februar 2019 um 10:01 geschrieben:
>
>
> 2019/02/08 10:32 ... Walter Harms:
> > Hello list,
> > i run into an unexpected problem with mysqldump:
> >
> > mysqldump --version
> > mysqldump Ver 8.0.12 for Lin
> Halaasz Saandor hat am 9. Februar 2019 um 10:01 geschrieben:
>
>
> 2019/02/08 10:32 ... Walter Harms:
> > Hello list,
> > i run into an unexpected problem with mysqldump:
> >
> > mysqldump --version
> > mysqldump Ver 8.0.12 for Lin
Hello list,
i run into an unexpected problem with mysqldump:
mysqldump --version
mysqldump Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL)
when i try it results in:
mysqldump: Error: 'Lost connection to MySQL server during query' when trying to
dump tablespaces
mysqldump: Couldn't
Am 02.12.2014 18:31, schrieb Johan De Meersman:
> - Original Message -
>> From: "wharms"
>> Subject: signal handling in mysql cli
>>
>> when i use CTRL-C to break a query that works fine in interactive mode.
>>
>> but when i use the noninteractive mode
>> i looks like that but "show ful
hi list,
when i use CTRL-C to break a query that works fine in interactive mode.
mysql> select sleep(10) ;
^CCtrl-C -- sending "KILL QUERY 24289" to server ...
Ctrl-C -- query aborted.
+---+
| sleep(10) |
+---+
+---+
1 row in set (0.86 sec)
but when i use the noninteracti
hi,
does the value change at all like below ?
mysql> show global variables like 'timestamp';
+---++
| Variable_name | Value |
+---++
| timestamp | 1372404355 |
+---++
1 row in set (0.00 sec)
mysql> show global varia
Am 13.06.2013 12:07, schrieb Hartmut Holzgraefe:
> On 06/13/2013 09:41 AM, walter harms wrote:
>
>> Hello Manuel,
>> thx for your tip. We caught the problem when we moved to partitions.
>> Strange is that
>> while testing the problem did not show up and even now w
Am 12.06.2013 12:33, schrieb Manuel Arostegui:
> 2013/6/12 walter harms
>
>>
>> Hi list,
>> i am trying to understand the incredible use of filepointers in our mysql
>> server (5.1.53).
>> under normal condition the server reports 10k-15k open files pointer
Am 05.04.2013 07:56, schrieb Keith Keller:
> On 2013-04-05, Nitin Mehta wrote:
>>
>> We're trying to upgrade our existing MySQL 5.1.26 to MySQL 5.1.68 but the
>> installation gives error:libc.so.6(GLIBC_2.4) is needed by
>> MySQL-server-community-5.1.68-1.rhel5.i386 rtld(GNU_HASH) is needed by
Am 02.02.2013 01:34, schrieb Larry Martell:
> On Mon, Jan 28, 2013 at 5:01 AM, walter harms wrote:
>> hi list,
>>
>> i am using mysql 5.1.53.
>> after a crash i have the follwing error in my log:
>>
>> 130128 10:45:25 InnoDB: Error: page 61 log sequence n
ables)
only they ibdata1-file or is there more ?
re,
wh
>
> On Mon, Jan 28, 2013 at 2:21 PM, walter harms wrote:
>
>>
>>
>> Am 28.01.2013 15:01, schrieb Manuel Arostegui:
>>> 2013/1/28 walter harms
>>>
>>>> hi list,
>>>>
&
>
For now i tend to solution 3, rsync
do you know is it possible only certain files ?
re,
wh
>
> On Mon, Jan 28, 2013 at 12:01 PM, walter harms wrote:
>
>> hi list,
>>
>> i am using mysql 5.1.53.
>> after a crash i have the follwing error in my log:
>>
Am 28.01.2013 15:01, schrieb Manuel Arostegui:
> 2013/1/28 walter harms
>
>> hi list,
>>
>> i am using mysql 5.1.53.
>> after a crash i have the follwing error in my log:
>>
>> 130128 10:45:25 InnoDB: Error: page 61 log sequence number 0 2871649158
&
perhaps you are looking for something like
select entry,timestamp from table A where A.timestamp=(select max(B.timestamp)
from table B where a.entry=b.entry);
also this oage may be helpful:
http://www.artfulsoftware.com/infotree/queries.php
re,
wh
Am 30.11.2012 02:39, schrieb h...@tbbs.net:
can you reduce the UDF just to return 1; ?
that should give you a clue what is going on. Random
values usualy point to two suspects
1. mixing 32bit and 64bit
2. using void instead of int
re,
wh
Am 04.11.2012 23:23, schrieb Stefan Kuhn:
> Hi all,
> I have a weired (for me at least) problem with
(why can a failed optimisation cause a table
corruption ?)
re,
wh
> All of MySQL (not just InnoDB) needs "tmp" space for _some_ queries. It is
> normally not be this same directory, but it is probably harmless if it is.
>
>> -Original Message-
>> Fr
Am 29.10.2012 14:55, schrieb Reindl Harald:
>
>
> Am 29.10.2012 14:54, schrieb walter harms:
>>
>>
>> Am 29.10.2012 13:17, schrieb Reindl Harald:
>>>
>>>
>>> Am 29.10.2012 12:48, schrieb walter harms:
>>>> hi list,
>&g
Am 29.10.2012 13:17, schrieb Reindl Harald:
>
>
> Am 29.10.2012 12:48, schrieb walter harms:
>> hi list,
>> does someone know under what circumstances ''optimize tables'' will
>> create a tmpfile?
>
> under all if it is MyISA
hi list,
does someone know under what circumstances ''optimize tables'' will
create a tmpfile ?
we had a strange case of "out of space" that seems related to an "optimize
table"
but i was unable to replicate that case exactly as that no tmpfile appeared.
(The table has a lot of partitions if that
Am 28.10.2012 21:50, schrieb Reindl Harald:
>
>
> Am 28.10.2012 21:29, schrieb walter harms:
>> hi list,
>>
>> on my system this this directory contains ib_logfile0/ib_logfile1, so far no
>> problem.
>>
>> From the documentation i had the impres
hi list,
on my system this this directory contains ib_logfile0/ib_logfile1, so far no
problem.
>From the documentation i had the impression that this is everything and
the files size should not change.
but it seems that immodb also uses this space for temp space, do they make
a copy of ib_logfi
Am 23.07.2012 17:38, schrieb Reindl Harald:
>
>
> Am 23.07.2012 17:35, schrieb walter harms:
>>
>>
>> Am 23.07.2012 16:58, schrieb Ananda Kumar:
>>> so. its more of inactive connections, right.
>>> What do you mean by NEVER LOGOUT
>>>
&g
2 at 8:17 PM, walter harms wrote:
>
>>
>>
>> Am 23.07.2012 16:37, schrieb Ananda Kumar:
>>> why dont u setup a staging env, which is very much similar to your
>>> production and tune all long running sql
>>>
>>
>> They are tuned and they ar
3, 2012 at 8:02 PM, walter harms wrote:
>
>>
>>
>> Am 23.07.2012 16:10, schrieb Ananda Kumar:
>>> you can check the slow query log, this will give you all the sql's which
>>> are taking more time to execute
>>>
>>
>> Yes but you will
select * from information_schema.processlist where state like 'executing' and
time > 1000 ;
unfortunately time i cumulative and i would kill long running processes that we
have also.
i guess i will make some assumptions about the statement and kill the rest.
re,
wh
> On Mon, Jul 23, 2012 a
gt;
> On Mon, Jul 23, 2012 at 6:18 PM, walter harms wrote:
>
>> Hi list,
>> is there a switch where i can restrict the connect/execution time for a
>> query ?
>>
>> re,
>> wh
>>
>> --
>> MySQL General Mailing List
>> For list
Hi list,
is there a switch where i can restrict the connect/execution time for a query ?
re,
wh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Am 26.01.2012 18:45, schrieb HalXsz SXndor:
> 20120126 10:34 AM +0200, a bv
> Database contains
> tables (structures?) which gets montly data , and these tables are
> named as
>
> name1_name2_ yearmonth . I only want to have the whole database system
> for last 2 years, and automaticly
Am 10.09.2011 17:32, schrieb a.sm...@ukgrid.net:
> Quoting walter harms :
>
>> I still do not see why it is restarting ... there must be something
>> watching is disappear.
>> Just to be sure, you do from a remote host: mysql -hHOST -ume -e "show
>> tables&quo
Am 10.09.2011 16:25, schrieb a.sm...@ukgrid.net:
> Quoting walter harms :
>
>>
>> What i found odd that your mysqld actualy restarts.
>> Do you have it in some runlevel ? if yes stop and see
>> what happens.
>> If this does not work simple move the mysqld ou
Am 10.09.2011 16:07, schrieb a.sm...@ukgrid.net:
> Ok, this is pretty odd but I have found the problem.
>
> Today I have repointed all applications to a different DB server, so I
> have been free to do any testing on the problem server.
>
> I started by dropping the databases one by one, droppe
It is some time since i used AIX but maybe this help.
So far i know has IBM moved to gnu-tools if not do it,
it will ease the pain. I assume that you have gcc etc running.
after downloading the latest version of mysql source.
1. unpack
2. ./configure
if it complains try to fix it
/* hope for the be
Am 31.08.2011 13:51, schrieb Johan De Meersman:
> Exactly the same data, too? Different index leaf distribution might account
> for something
>like this, and it does look like you're retrieving different datasets.
>
same data
think of it as a backup.
re,
wh
--
MySQL General Mailing List
hi list,
i have a very strange effect.
I have two boxes with the same DB ( same version, same tables, same my.cnf, etc)
I was trying to optimise an sql statement and used desc to see what is going on
and found to my surprise two different results.
Can this be the result of the optimizer ? (the bo
maybe its is obvoius but
did you look at the statistics ?
did you try "optimize table" ?
re,
wh
Am 18.07.2011 18:40, schrieb A F:
> [Process:]
>
> Importing
> delimited text files from a Windows based server to a MySQL 5.1.41 instance
> (multiple databases) on a single Ubuntu 10.04.2 host.
>
from:http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html
SET GLOBAL time_zone = timezone;
from:http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_utc-timestamp
* UTC_TIMESTAMP, UTC_TIMESTAMP()
I have the same results, according to the docs timezone is the offs
Am 19.06.2011 21:06, schrieb sono...@fannullone.us:
> On Jun 19, 2011, at 11:11 AM, Claudio Nanni wrote:
>
>> just a quick debug:
>
> Thanks, Claudio. It turned out to be that NOW() was using the server's
> time and my timestamp was based on my timezone. After fixing that, the
> SELEC
a vitual machine
with qemu, or
simply buy a 32bit box is more maintainable than mixing 32 und 64 bit
application. They can run
perfectly until some random momentum.
re,
wh
> Alex
>
> On Sat, Jun 4, 2011 at 10:06 AM, walter harms wrote:
>
>> It is basicly a not clever solu
It is basicly a not clever solution to run 32bit libs with a 64bit system.
You have to compile -m32 and all sort of things.
It is *way* better to compile with pure 64bit.
re,
wh
Am 04.06.2011 02:18, schrieb Alex Gaynor:
> I've got a 64-bit Linux system, with a 32-bit libmysqlclient (and a 64-bit
maybe but what is mysql 11.4 ?
re,
wh
Am 27.04.2011 03:33, schrieb Sharl.Jimh.Tsin:
> very useful tool,is it free?
>
> Best regards,
> Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)
>
>
>
> 2011/4/26 SQL Maestro Team :
>> Hi!
>>
>> SQL Maestro Group announces the release of PHP
You are missing the libmysqlclient.
I guess the problem is your makefile. make != shell
You CFLAGS should have something like this:
-L/usr/lib/mysql -lmysqlclient
(Actualy it should be LDFLAGS and LOADLIBES)
something like $(shell pkg-config --cflags $(packages) ) should work
further reading:
h
Carlos Mennens schrieb:
> I have a database called 'gaming' and with in that database there are
> several tables and data. I was asked to find a module called 'ako
> ldap' and disable it (setting it from 1 to 0). My question is how in
> MySQL do I search for a string if I don't even know what tab
PRATIKSHA JAISWAL schrieb:
> Hi List,
>
> Can somebody please help me if they have a script using which we can get an
> idea for installed mysql server, backup, created databases, indexes, tables,
> engines, replication etc...
>
> I will appreciate your help in advance
>
>
You can find t
you can circumvent the problem by using stdout.
just drop the "INTO OUTFILE '/tmp/result.txt'".
the result should look something like that:
mysql -BAN -e "select ..." >filename
you can also pipe truh gzip to compress the file and save
a lot of space.
re,
wh
note: i found ";" is not a good se
Huib schrieb:
>
> Hello,
>
> I hope that this is the right list.
>
> I have a database that has been running for years in latin1 but a
> software update changed it in to utf8 that would be no big deal if we
> know it right away so we could change the database.
>
> The big problem is that the
Nathan Harmston schrieb:
> Hi everyone,
>
> I am currently working on an application where I have a very large
> table called intervals ( atm its 80 000 000 records and growing ), and
> a smaller table ( token ) which join with it.
>
> interval is just an id, start, end, word
> token is id, int
Krishna Chandra Prajapati schrieb:
> Hi list,
>
> I want to insert 1 records/sec into table. There can be n number of
> tables with unique data in each. What are the possible ways to do ?
>
i prefer mysqlimport. just sort your output into a file that is named like the
table
you wish to i
Jerome Macaranas schrieb:
> im trying to setup mysql slave but the things is it wont start because of
> this errror:
>
> --> ERROR 1200 (HY000): The server is not configured as slave; fix in config
> file or with CHANGE MASTER TO
>
> after some testing.. i saw the server-id = 0
> through > show
hi list,
is it possible to get a list of all tables with a certain type in one statement
?
for now i collect all tables (show tables) and search for the type (show
columns).
Any way to circumvent that ? make it one statement ?
re,
wh
--
MySQL General Mailing List
For list archives: http://
I do know thw internals,
but i guess having "select" only would be enough if you drop the "auto-repair"
feature.
a "repair" always requires changes (=write).
maybe you can use mysqlldump instead ?
re,
wh
René Fournier schrieb:
> Just wondering what they are. I'd rather not use the MySQL root use
Manasi Save schrieb:
> Hi All,
>
> I am needing to access a sub databases through main database.
>
> I have one main database and serveral sub databases. For accessing those
> databases I am using mysql prepared statements, But the performance I am
> getting because of this is very low.
>
> Ca
Sydney Puente schrieb:
> Hello,
> I want to log all sql queries made against a mysql db.
> Googled and found I should add a line to my.cnf.
>
> However I cannot find a my.cnf file
> [r...@radium init.d]# ps -ef | grep mysql
> root 13614 1 0 Sep24 ?00:00:00 /bin/sh /usr/bin/mysql
Jaime Crespo Rincón schrieb:
> 2009/10/29 Michael Dykman :
>> mysqldump is not really a data manipulation tool.. as the name
>> implies, it is a dumper.
>>
>> What you are trying to accomlish can be done rather elegantly via the
>> SELECT .. INTO OUTFILE syntax
>>
>>http://dev
Do your realy need to know the differenz ? take everything as "string".
(breaks with pics/geodata but helps a lot).
re,
wh
sangprabv schrieb:
> Hi,
> I found no built in function in mysql to check whether a record is
> numeric or string. Is there any trick to do so? Many thanks.
>
>
>
>
> Wi
Krishna Chandra Prajapati schrieb:
> Hi list,
>
> I have two tables send_sms and alt_send_sms. Users are inserting records
> into send_sms @ 500/sec ie 3/min. After applying some updates to
> send_sms data are transferred to alt_send_sms and deleted from send sms. The
> same thing is happeni
Simon Kimber schrieb:
> Hi Everyone,
>
> I'm having a very simple query often take several seconds to run and
> would be hugely grateful for any advice on how i might spped this up.
>
> The table contains around 500k rows and the structure is as follows:
>
> +---+--+
The letter is directed to EU based companies. deadline is 13.08.2009.
Maybe some more are interessted to participate.
http://blog.thinkphp.de/archives/416-A-letter-from-the-European-commission-regarding-the-OracleSun-merger.html
re,
wh
disclaimer:
i have nothing to do with that stuff. i only f
create the corresponding select
statements ?
re,
wh
peng yao schrieb:
> you also can do this:#sudo -u mysql "mysqldump command"
> or
> #su - mysql -c "mysqldump command"
>
>
>
> 2009/7/24 walter harms
>
>>
>> muhammad subair schrieb:
>>&
muhammad subair schrieb:
> On Thu, Jul 23, 2009 at 10:10 PM, walter harms wrote:
>
>> Hi list,
>> i use mysqldump --tab to create database dumps. this will produce txt and
>> sql files.
>> the resulting sql files is owned by the user but the resulting dataf
Hi list,
i use mysqldump --tab to create database dumps. this will produce txt and sql
files.
the resulting sql files is owned by the user but the resulting datafile is
owned by mysql.mysql
is there any way to change that ?
re.
wh
--
MySQL General Mailing List
For list archives: http://list
bharani kumar schrieb:
> Hi All ,
> This is one general question ,
>
> How to write the safe query , which prevent the site from hijacker ,
>
> Share your idea's
pull the plug for the mains and save energy.
there is no silver bullet. take a lecture in security and you will scream
who much sim
st...@edberg-online.com schrieb:
> At 11:10 AM +0530 6/13/09, Krishna Chandra Prajapati wrote:
>> Hi guys,
>>
>> I'm working in a telecom company. I have table called deliverylog in which
>> 30 million records gets inserted per/day. The table has grown to 0.5TB I
>> have to keep 60days record in
hi Olaf,
in unix you have small programms that do one thing and not more.
What you want to archive is a compressed output files.
the most easy way is:
| gzip -c >outfile
depending on your data replace gzip with zoo,lha,bzip2,compress,.
re,
wh
Olaf Stein schrieb:
> Or even better, can I
Ravi raj schrieb:
> Dear walter Harms,
>
> Thanks for your valuable solution, but in the code which
> you provided is printing only one row , if i try to print whole table,
> or 2, or 3, columns fully means its giving segmentation fault, kindly
> check the belo
hi list,
i am wondering if there is a way to reduce the number of open files.
The database has InnoDB and MyISAM. I have a lot a partitions is that a problem
?
(To many open files causes problems for mysqldump)
running is vanilla 5.1.34
show status like '%open%' ;
+--+--
hi ravi,
this works for me. it should help
you to get a starting point
re,
wh
/*
simpple DB connect test
gcc -L/usr/lib/mysql -lmysqlclient connect.c
*/
#define _GNU_SOURCE
#include
#include
#include
int main()
{
MYSQL *MySQL;
MYSQL_ROW row;
MYSQL_RES *res;
there is nothing you can make.
Any (major)upgrade of mysql client requires the dependent subsystem to upgrade
also.
Anything else would be careless since you do not know if the interface has
changed.
basicly you can install both version of libraries and hope for the best. i
would do this only
Didier Godefroy schrieb:
> Hello all,
>
> I've been having troubles building mysql on Tru64 v5.1b.
> I tried several versions and there are always some kind of issues with
> undefined symbols and things to be changed in the source to allow the build
> to continue.
> Lately I've been trying to ge
most likely a missing include it should have at least:
#include
#include
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
schrieb:
> make all-am
> Making all in mysql-test
> Making all in lib/My/SafeProcess
> g++ -DHAVE_CONFIG_H -I. -I../../../../include -O3
you may like to try "mytop"
or
watch -n10 mysql -BNA -e "show full processlist"
add user,host,databasename as needed
Sven schrieb:
> Hi folks
>
> I am searching for a generic command to monitor that MySQL instance is
> up and running. I don't have any know-how about the schema of the DB.
>
>
Kunal Jain schrieb:
> How we can configure Mysql in such a way so that i start using all the cores
> of CPU. I Have a QuadCore server but somehow mysql use only single core
> whose usage percentage goes upto 99% while other three cores remains idle.
>
> Any Idea or Multiple Core/CPU is wastage.
Kevin Stevens schrieb:
> ello,
> I am encountering a problem I just can't seem to figure out and I am out of
> ideas. I can compile and run fine on one linux box running Mysql 5.1.23-rc,
> but as soon as I scp the binary and its required libs to another machine
> which has identical hardware a
hi ronaldo i tried and failed.
it seems that mysql has no option to specify a select statement.
did i mis something ?
re,
wh
walter harms schrieb:
> hi ronaldo,
> iadmit i was mysql (the command) fixated :)
>
> thx a lot,
> wh
>
> Rolando Edwards schrieb:
>> Try
By default, its output to stdout.
>
> Give it a try !!!
>
> -Original Message-
> From: walter harms [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 16, 2008 5:06 AM
> To: 'mysql'
> Subject: select ... into outfile=stdout ?
>
> hi list,
> i need some options
hi list,
i need some options from outfile (exspecialy:FIELDS TERMINATED BY) and would
like
to send the output to stdout to further processing.
unfortunately i found no proper way to force the output to stdout. for now i use
the redirection of the "mysql -NB" output but the interface lacks the opt
Mike Aubury schrieb:
> Excellent - this seems to be the issue - the show create table shows :
>
> mysql> show create table a\g
> +---++
> | Table | Create
> Table
you mail like to find it by your self. simply use : explain
re,
wh
Yong Lee schrieb:
All,
Just curious as to which query would be better in terms of performance:
select * from (select * from a union select * from b) as c;
versus
select * from a union select * from b;
or would these
thx,
the results support my suspect
re,
wh
Perrin Harkins schrieb:
On Fri, Aug 29, 2008 at 4:57 AM, walter harms <[EMAIL PROTECTED]> wrote:
Since diskspace is plenty i thinking about to use the name directly. does
anyone has any idea
what is the performance penalty ?
Hi list,
I need to store what is basically a key-value pair. A few years ago i would
have choosen
an integer as key and used a translation table to get the name (char[]) for the
key.
Since diskspace is plenty i thinking about to use the name directly. does
anyone has any idea
what is the perfo
Vicente Moreno schrieb:
Hi all I have a little question, have you ever work C & MYSQL??? all about that
is new for me, if anybody has some info, help me!!!
yes,
re,
wh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/
Keith Spiller schrieb:
Hi Johnny,
Yeah. Sadly I missed the fact that the zip codes were hacked in our original
Works to MySQL conversion until long after I had imported the data into our
current MySQL table. Now we have to fix the numbers in our MySQL table and
guarantee that we can expor
Kandy Wong wrote:
> Hi Saul,
>
> I need to use C++ and I'm not writing a web application.
> Thanks anyway.
you can do something like:
select min(abs(timediff("",timestamp))) from where
;
if you use the libmysql you can get the result as strings back (the method i
prefer) and convert the
Waynn Lue wrote:
> Out of curiosity, is it generally faster to do a sub query or do it in
> code for something like this.
>
> Schema of Settings table, where the PK is (ApplicationId, SettingId):
> ApplicationId, SettingId, SettingValue
>
> Select SettingValue from Settings where SettingId = 10
that is a shell question using bash/ksh stuff you can use this:
mysql -uroot -pxxx -Dtest -s -e 'select * from amc_25;' > 1.txt 2>&1
Ananda Kumar wrote:
> The problem with below statement is that, if i there is any error in sql
> statements it does not get written to 1.txt. So, even
hi list,
i have a simple question:
does the constraint id need to be numeric ?
re,
wh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
David Ruggles wrote:
> I may be approaching this all wrong, but I need to know a percentage of
> total sales within a select statement.
>
> So I can do something like this:
> Select company, state, sales, sum(sales) / sales as percent
> From Sales
>
>
mmh, you want
sum(sales where compan
Peter Brawley wrote:
>> to get the latest value for each id i have queries like:
>
>> select * from tab A where timestamp = (select max(timestamp) from tab
>> B where B.id=A.id) group by id ;
>
> See "Within-group aggregates" at
> http://www.artfulsoftware.com/infotree/queries.php.
>
> PB
>
hi list,
i have tables that look like this( <10.000 entries) :
id,
timestamp,
value
to get the latest value for each id i have queries like:
select * from tab A where timestamp = (select max(timestamp) from tab B where
B.id=A.id) group by id ;
on a fast system it takes round 4 sec to complet,
88 matches
Mail list logo