I get: syntax error near '@dummy, col1, col2, col3, @dummy, col4, @dummy' on Line 1GM wrote:I can't make any guarantees, but for me the query I posted seemed to work in MySQL 5.0.2 (albeit with a single line of input).
Upgrading may affect other databases you've got, so proceed with caution if you choose this route.
Maybe someone else out there will be good enough to run a couple of tests in a MySQL 4 environment? As onion2k says, I find it strange that it isn't supported.
What is the exact error that you get when you try to run the query I posted?
Once I get rid of @dummy then it works fine, but obviously with the columns i don't want too.
I will try upgrading to 5 and see if it makes any difference.
Thanks a lot for all your help