Gaspar Bakos <[EMAIL PROTECTED]> wrote: > > I am trying to duplicate a row of a table in the following way: > > insert into Observer select * from Observer where OBid = 4; > ERROR 1066: Not unique table/alias: 'Observer' > > It is a unique table; I mean there can't be another table named in the > same way. > > Any pointer would be welcome. Probably trivial, but got stuck.
Before version 4.0.14 you can't insert data in the same table as you use in the FROM clause of the SELECT part. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
