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.
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
