List:General Discussion« Previous MessageNext Message »
From:George Christoforakis Date:July 14 2003 8:46am
Subject:Re: How to copy records in one table?
View as plain text  
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.

George Christoforakis.
PS: You don't mention your mysql version. Is this sql the exact command?

----- Original Message -----
From: "George Georgeus" <george_georgeus@stripped>
To: <mysql@stripped>
Sent: Monday, July 14, 2003 10:54 AM
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:
http://lists.mysql.com/mysql?unsub=1
>
>


Thread
How to copy records in one table?George Georgeus14 Jul
  • Re: How to copy records in one table?George Christoforakis14 Jul
    • Re[2]: How to copy records in one table?Krasimir_Slaveykov14 Jul
  • Re: How to copy records in one table?Victoria Reznichenko14 Jul
    • Re: How to copy records in one table?Sergei Golubchik14 Jul