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 Link to comment https://forums.phpfreaks.com/topic/73765-moving-data/ 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 Link to comment https://forums.phpfreaks.com/topic/73765-moving-data/#findComment-372185 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. Link to comment https://forums.phpfreaks.com/topic/73765-moving-data/#findComment-372205 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.