'MariaDB Exchange partition data

Database : Maria DB 10.6.5

Issue: Data transfer from partitioned table to Non-Partitioned table

  • Table A - partitioned on Date (range partitioned)
  • Table B - Not partitioned.

Both tables are exactly same without partition.

Case 1:

Transfer data from table A to B It is successful.

Case 2:

Now again transfer data from Table A into table B(having case 1 data).

Data transfer successful but , table B existing data gets transferred back to table A.

How to prevent that? Table B existing data should not move back to table A

Any help will be of great value.

regards Anand



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source