For a while my application should support both mysql 4 and 5 ( teh same copy
on different sites of course ) so I should keep using a soluting wich should
works well on both revision.
I also have a couple of server with their database configured as master
slave, so I don't trust to use
select ( select max(c.idrow)+1 from provasql c ) , 'This is only a test';
Does changing max(c.idrow)+1 to coalesce(max(c.idrow),0)+1 solve
your problem?
--Pete
On Fri, Nov 04, 2005 at 04:56:26PM +0100, AESYS S.p.A. [Enzo Arlati] wrote:
For a while my application should support both