Hello George, Monday, July 14, 2003, 11:46:06 AM, you wrote:
Read this: http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html GC> as far as i know, mysql version 4.0 and previous, do not support subqueries. GC> Select in select doesn't work. GC> Have a look in the manual if what u r trying to do is supported. GC> George Christoforakis. GC> PS: You don't mention your mysql version. Is this sql the exact command? GC> ----- Original Message ----- GC> From: "George Georgeus" <[EMAIL PROTECTED]> GC> To: <http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html> GC> Sent: Monday, July 14, 2003 10:54 AM GC> 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: GC> http://lists.mysql.com/[EMAIL PROTECTED] >> >> -- Best regards, Krasimir_Slaveykov mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
