Moving columns from one table to another

[gergy008]

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 ^^

[PFMaBiSmAd]

http://dev.mysql.com/doc/refman/5.0/en/insert-select.html

[The Little Guy]

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!