1.下载解压h2
2.根目录下新建.h2.server.properties
webAllowOthers=true webPort=8082
3.导入导出
call CSVWRITE ( 'e://h2/articles.csv', 'SELECT * FROM articles' )
CREATE TABLE TEST AS SELECT * FROM CSVREAD('test.csv')
Louyj的博客
记录所思,分享所得。
webAllowOthers=true webPort=8082
call CSVWRITE ( 'e://h2/articles.csv', 'SELECT * FROM articles' )
CREATE TABLE TEST AS SELECT * FROM CSVREAD('test.csv')
No Leanote account? Sign up now.