Moving lines on a MySQL database

Hello

- I have 2 identical tables in the same MySQL database
- I want to copy some content of the first one to the second one

Any idea how to do this without using INSERT the DELETE ???

Isn't there any "moving" function ?

re: Moving lines on a MySQL database

Are you kidding ?
What is "move" ?

"Lakigam" <jesse@lakigam.com> ¦b¶l¥ó
news:1123161469.726659.73230@o13g2000cwo.googlegro ups.com ¤¤¼¶¼g...[color=blue]
> Hello
>
> - I have 2 identical tables in the same MySQL database
> - I want to copy some content of the first one to the second one
>
> Any idea how to do this without using INSERT the DELETE ???
>
> Isn't there any "moving" function ?
>[/color]

re: Moving lines on a MySQL database

Move is an insert followed by a delete :)