How to migrate table data in h2

2023-12-06 h2

CSVWRITE and CSVREAD functions can be used to migrate the data from a database to another database.

call CSVWRITE('t.csv', 'select * from managements where a > 100');

delete from managements where a > 100;
insert into managements select * from CSVREAD('t.csv');