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" <ge*************@yahoo.com>
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/my***********...ratiogroup.com
--
Best regards,
Krasimir_Slaveykov mailto:kr***@hq.office1.bg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw
