Can I export tables from a one database and import it into another database that does not have the exported tables? I mean if I import into a database that has no tables, will the import create the tables automatically for me?
Printable View
Can I export tables from a one database and import it into another database that does not have the exported tables? I mean if I import into a database that has no tables, will the import create the tables automatically for me?
Absolutly. I creates all the schemas before putting the data.
Yes, it will automatically create the table. You could try by exporting a table, drop it, then import.