gergy008 Posted November 29, 2009 Share Posted November 29, 2009 Hi, I want to copy all the rows in the `users` table, But only include the `login` column and the `email` column. How do I do it? The amount of rows is too much to do it manually, Trust me, Alot of users xD Thanks in advance ^^ Quote Link to comment https://forums.phpfreaks.com/topic/183261-moving-columns-from-one-table-to-another/ Share on other sites More sharing options...
PFMaBiSmAd Posted November 29, 2009 Share Posted November 29, 2009 http://dev.mysql.com/doc/refman/5.0/en/insert-select.html Quote Link to comment https://forums.phpfreaks.com/topic/183261-moving-columns-from-one-table-to-another/#findComment-967220 Share on other sites More sharing options...
The Little Guy Posted November 29, 2009 Share Posted November 29, 2009 If you have phpmyadmin: 1. View the table structure 2. Click operations 3. Fill out the bottom right form Copy table to (database.table): 4. Click "Go" 5. Go to the new table 6. Place a check next to the rows you don't want 7. Click the drop icon Your done! Quote Link to comment https://forums.phpfreaks.com/topic/183261-moving-columns-from-one-table-to-another/#findComment-967334 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.