S
S
Skrolea2016-07-09 23:16:55
MySQL
Skrolea, 2016-07-09 23:16:55

Can you tell me how to make a request?

There are two bases db1 and db2 - in it there are identical tables
I need to transfer the data from the table of one base to the same table of other base. How to make a dump from a specific ID (well, for example, make a dump from ID=230 to ID=320 ?

mysqldump -uroot -p db1 table_name --where='id<320' ....

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dmitry Vapelnik, 2016-07-10
@dvapelnik

could be something like this:
It worked for me as expected. try

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question