PHWinfo - Afficher un message - Problem with INSERT INTO ... SELECT with HAVING clause

07/02/2008, 13h14

On 6 Feb, 20:35, PleegWat
<pleegwat.REM...@CAPS.leegwater-68.nl.INVALID> wrote:
> Hi,
>
> I've got a problem with a complicated INSERT INTO ... SELECT statement.
> It works correctly in mysql 5.0.45, but I've had complaints it doesn't
> work in 4.1, and according to the documentation it shouldn't work in any
> version.
> Any
> options I'm overlooking?

One option that you're overlooking is to tell us more than "it doesn't
work". What is the precise error that is being observed?

You also say: "according to the documentation it shouldn't work in any
version.". How about pointing us to the precise piece of documentation
that says that?

07/02/2008, 13h14	#2
Captain Paralytic Messages: n/a Hébergeur:	Re: Problem with INSERT INTO ... SELECT with HAVING clause On 6 Feb, 20:35, PleegWat <pleegwat.REM...@CAPS.leegwater-68.nl.INVALID> wrote: > Hi, > > I've got a problem with a complicated INSERT INTO ... SELECT statement. > It works correctly in mysql 5.0.45, but I've had complaints it doesn't > work in 4.1, and according to the documentation it shouldn't work in any > version. > Any > options I'm overlooking? One option that you're overlooking is to tell us more than "it doesn't work". What is the precise error that is being observed? You also say: "according to the documentation it shouldn't work in any version.". How about pointing us to the precise piece of documentation that says that?