How to export specific column from specific table from database in phpmyadmin

Question

I want to add two specific column's data in another table's columns using same database in phpmyadmin. I know the way to solve this using .CSV file but anyone help me to figure out this without using .CSV file. How i can export that two specific column's data from one table and import that in another table using same database?

LHristov · Accepted Answer · 2014-07-29 07:20:14Z

4

INSERT INTO new_table (field1, field2)
  SELECT field1, field2
  FROM old_table

answered Jul 29, 2014 at 7:20

LHristov

1,1217 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to export specific column from specific table from database in phpmyadmin

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related