How to copy records in one table?

[George Georgeus]

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/my***********...ie.nctu.edu.tw

[ventre-à-pattes]

"George Georgeus" <ge*************@yahoo.com> wrote in message
news:be***********@FreeBSD.csie.NCTU.edu.tw...

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

biting your tail in an infinite loop...
create a temporary or heap table and use it as source
--
Eric Lafontaine

[ventre-à-pattes]

"George Georgeus" <ge*************@yahoo.com> wrote in message
news:be***********@FreeBSD.csie.NCTU.edu.tw...

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

biting your tail in an infinite loop...
create a temporary or heap table and use it as source
--
Eric Lafontaine