I'm not sure if this is a feature or not so i'll just report it as a possible bug.
I couldnt find anything in the documentation.
How to repeat:
create table t1(id int);
insert into t1 set id=0;
select @a:max(id)+1 from t1;
insert into t1 [EMAIL PROTECTED];
Result on master:
mysql select *
Hi,
...the sysntax it's not quite normal.You should try :
select @a:=max(id)+1 from t1;
To test if the variable @a is loaded with what you expect, you can do:
select @a;
...if the result is NULL something is working wrong.
Anyhow, i wonder how it works on the master ?
Regards,
Gelu
Scott Wong writes:
I'm not sure if this is a feature or not so i'll just report it as a possible bug.
I couldnt find anything in the documentation.
How to repeat:
create table t1(id int);
insert into t1 set id=0;
select @a:max(id)+1 from t1;
insert into t1 [EMAIL PROTECTED];
