L
L
Lyuba2018-04-06 10:15:46
MySQL
Lyuba, 2018-04-06 10:15:46

Copy columns from one table to another mysql?

Guys tell me how to copy tables from one mysql database to another?
5ac71e77eacd0278948194.png
The tables themselves are marked with a checkmark, do they need to be transferred to another database?
But there is a problem, I have a mysql database and from where I need to copy mysqli

Answer the question

In order to leave comments, you need to log in

2 answer(s)
L
Lazy @BojackHorseman MySQL, 2018-04-06
Tag

write manually an ALTER query for the second table, copying the field descriptions from the first CREATE query

I
Ildar Saribzhanov, 2018-04-06
@Bluz

phpmyadmin has an export and import procedure
Export first.
Method - usual, you select the necessary tables. Both structure and data
You press, I call it "forward". A .sql file will be created, save it.
Then you go to the desired database, click "import" and select your
Profit file

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question