is there a simple query I can use to move a row from one table to another?
Last edited by stickman373; Feb 27th, 2005 at 11:03 AM. Reason: solved
Depending on the database you are using you can use an INSERT/SELECT query. This will work in MySql for example: Code: INSERT INTO table (col1,col2,col3,col4) SELECT col1,col2,col3,col4 FROM othertable WHERE col1 > 5;
INSERT INTO table (col1,col2,col3,col4) SELECT col1,col2,col3,col4 FROM othertable WHERE col1 > 5;
PHP || MySql || Apache || Get Firefox || OpenOffice.org || Click || Slap ILMV || 1337 c0d || GotoMyPc For FREE! Part 1, Part 2 | PHP Session --> Database Handler * Custom Error Handler * Installing PHP * HTML Form Handler * PHP 5 OOP * Using XML * Ajax * Xslt | VB6 Winsock - HTTP POST / GET * Winsock - HTTP File Upload Latest quote: crptcblade - VB6 executables can't be decompiled, only disassembled. And the disassembled code is even less useful than I am. Random VisualAd: Blog - Latest Post: When the Internet becomes Electricity!! Spread happiness and joy. Rate good posts.
Forum Rules
move a row
Reply With Quote
