List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 22 2002 5:44pm
Subject:Re: Not unique table/alias
View as plain text  
At 19:22 +0200 10/22/02, Ciprian I. Acatrinei wrote:
>Hi,
>
>mysql> INSERT INTO f_baldai_seq (seq, nextval) SELECT seq, nextval+1 
>FROM f_baldai_seq LIMIT 1;
>ERROR 1066: Not unique table/alias: 'f_baldai_seq'
>
>Please help.

It's like it says in the manual: you cannot insert into the same
table that you're selecting from.

http://www.mysql.com/doc/en/INSERT_SELECT.html

>
>Thank's.

Thread
Not unique table/aliasCiprian I. Acatrinei22 Oct
  • Re: Not unique table/aliasVaso Koutsonikola22 Oct
  • Re: Not unique table/aliasPaul DuBois22 Oct