Hi, In mysql 4.014, the below INSERT statement works fine: INSERT INTO TEST_TABLE SELECT 20, name FROM TEST_TABLE WHERE id = 10
But in mysql 4.1, it fails, I get a message: Error Code : 1066 Not unique table/alias: 'TEST_TABLE' (10 ms taken) Question: Is this a problem with 4.1 or is it supposed to fail? thanks, Ramesh Table is: CREATE TABLE TEST_TABLE (id mediumint(9) NOT NULL, name varchar(255)) TYPE = InnoDB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
