469,082 Members | 1,242 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,082 developers. It's quick & easy.

Re[2]: How to copy records in one table?

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" <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

Jul 19 '05 #1
0 2822

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

19 posts views Thread by davidgordon | last post: by
669 posts views Thread by Xah Lee | last post: by
25 posts views Thread by tekctrl | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.