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.
PS: You don't mention your mysql version. Is this sql the exact command?
----- Original Message -----
From: "George Georgeus" <george_georgeus@stripped>
Sent: Monday, July 14, 2003 10:54 AM
Subject: How to copy records in one table?
> 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: