as far as i know, mysql version 4.0 and previous, do not support subqueries. Select in select doesn't work. Have a look in the manual if what u r trying to do is supported.
George Christoforakis. PS: You don't mention your mysql version. Is this sql the exact command? ----- Original Message ----- From: "George Georgeus" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 14, 2003 10:54 AM Subject: How to copy records in one table? > Hi, > > does anybody know how to copy a record within one > table? I am looking for some simple method similair to > INSERT INTO orders SELECT * FROM orders WHERE > Order_ID=256; Actually, this method does not work and > I can not believe that MySQL does not offer some > simple method how to do it. Keep in mind that I have a > 60-field table. So, naming all fields is a pretty > tedius task. > > Thaks Ge0rge > > ________________________________________________________________________ > Want to chat instantly with your online friends? Get the FREE Yahoo! > Messenger http://uk.messenger.yahoo.com/ > > -- > 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]
