Hello, how to copy information from one database to another?
for example
There are two databases
1. db_one
2. db_two
The database
db_one there's information it must be "Copy" in the
db_two
but so that was auto_increment
for example copy
Code:
1. db_one - (id - auto_increment)
id|player|playerip
1|Player 1|127.0.0.1
2|Player 2|127.0.0.2
3|Player 3|127.0.0.3
4|Player 4|127.0.0.4
5|Player 5|127.0.0.5
Code:
2. db_two - (id - auto_increment)
id|player|playerip
You need to copy
Player 3 in the
db_two
After copying is obtained
Code:
1. db_one - (id - auto_increment)
id|player|playerip
1|Player 1|127.0.0.1
2|Player 2|127.0.0.2
3|Player 3|127.0.0.3
4|Player 4|127.0.0.4
5|Player 5|127.0.0.5
Code:
2. db_two - (id - auto_increment)
id|player|playerip
1|Player 3|127.0.0.3
how to do so?