Importing sql file data omitting columns (MySql)

Question

I am building a new booking system in PHP at the moment and I want to take over most of the data of the old system (MySQL) however the database structure of the new system will be slightly different. However I think I could take over some of the tables. Is it possible to import rows of old tables to the new table given that the column names are equal but some column names in the new table might be missing?

an example, the old table: tourguides id name address email telephone_mobile telephone_home

the new table tourguides id name address telephone_mobile

the new table doesn't has the column telephone_home, this shouldnt stop the import but instead it should be ignored

If you are importing through a sql file or csv file then it will give you error but if you try INSERT INTO new_tourguides (id,name,address,telephone_mobile) SELECT id, name, address, telephone_mobile FROM old_touguides then you shouldn't have any probems. — Think Different
– Think Different, Commented Sep 10, 2014 at 12:59
Thanks very much Think Different and thiago, thats it. All the best — Mike Noon
– Mike Noon, Commented Sep 10, 2014 at 13:13

thiago marini · Accepted Answer · 2014-09-10 13:04:27Z

1

Yes, it's possible.

You should do an INSERT SELECT with fixed fields, like this:

INSERT INTO table1 (fieldX, fieldY) SELECT fieldX, fieldY FROM table2

You can even do it between databases:

INSERT INTO db1.table1 (fieldX, fieldY) SELECT fieldX, fieldY FROM  db2.table2

answered Sep 10, 2014 at 13:04

thiago marini

5443 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

Importing sql file data omitting columns (MySql)

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