Hi, 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. Cheers Gaspar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
