Welcome to Dream.In.Code
Getting PHP Help is Easy!

Join 136,056 PHP Programmers for FREE! Get instant access to thousands of PHP experts, tutorials, code snippets, and more! There are 1,591 people online right now. Registration is fast and FREE... Join Now!




Moving Rows.

 
Reply to this topicStart new topic

Moving Rows.

Dr. Tim
17 Nov, 2002 - 04:50 PM
Post #1

D.I.C Addict
****

Joined: 20 Mar, 2002
Posts: 993

How would I move a row using simple SQL statements without repeating the variables from another MYSQL query? I want to move an entire row from the table 'verify' to 'cnews'. Any help would be great. Thanks.
User is offlineProfile CardPM
+Quote Post

klewlis
RE: Moving Rows.
17 Nov, 2002 - 09:39 PM
Post #2

cur tu me vexas?
*****

Joined: 9 Nov, 2001
Posts: 1,723

I'm pretty sure that the only way would be to retrieve them and then insert them, in two different statements... I'm not sure if SQL can do that on its own (but someone correct me if I'm wrong!)
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 12/1/08 06:00PM

Live PHP Help!

PHP Tutorials

Reference Sheets

PHP Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month