Very straightforward if the new column is NULLable OR has a deterministic value, e.g.
INSERT INTO newtable (col1, col2) SELECT col1, 1 FROM oldtable WHERE ID = xxx Or if NULLable: INSERT INTO newtable (col1) SELECT col1 FROM oldtable WHERE ID = xxx Equally you could populate 'col2' from an expression or similar, calculating the value from data already in oldtable. Is this what you meant? If not, what exactly are you trying to do? Thanks, Matt -----Original Message----- From: Vinay [mailto:[EMAIL PROTECTED] Sent: 24 March 2004 18:09 To: [EMAIL PROTECTED] Subject: SQL statement Is their a way of using insert into newtablename select * from oldtablename where ID=xxx But with an aditional column in newtablename V!nay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]