Answer the question
In order to leave comments, you need to log in
Copy columns from one table to another mysql?
Guys tell me how to copy tables from one mysql database to another?
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
write manually an ALTER query for the second table, copying the field descriptions from the first CREATE query
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 questionAsk a Question
731 491 924 answers to any question