cs1h Posted October 18, 2007 Share Posted October 18, 2007 Hi, Does anyone know how to move one row from a table in a mysql database to another table using php? Thanks Colin Quote Link to comment Share on other sites More sharing options...
PHP_PhREEEk Posted October 18, 2007 Share Posted October 18, 2007 Well, assuming all of the fields match up... select * from the 1st table then insert into the new table also assuming you know the basic format(s) for those queries. PhREEEk Quote Link to comment Share on other sites More sharing options...
Wuhtzu Posted October 18, 2007 Share Posted October 18, 2007 You can easily do it with phpMyAdmin: MyTable -> Operations -> Copy table to (database.table) That of course does the exact same that as the code PHP_PhREEEk purposed. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.