Java JDBC/SQLite:将表导出到sql语句 [英] Java JDBC/SQLite: Export tables to sql statements

问题描述

我目前正在用Java处理SQLite数据库. 但我想将所有表及其数据导出到SQL语句.

I'm currently working with a SQLite database in java. But I would like to export all the tables and their data to SQL statements.

我尝试使用:

"SELECT * FROM TABLENAMES INTO OUTFILE '...'

但是这给了我一个错误:"int" int附近:语法错误"

But that gives me an error: " near "INTO": syntax error "

推荐答案

要实现此目的，您可以使用外部软件，例如SQLDeveloper或

To achieve that, you can use outer software, such as SQLDeveloper or SQLAdministrator. IntelliJ in Ultimate edition also supports exporting table data.

更新:

如果您只想使用sql导出它，则可以使用

If you want to export it using only sql you can use

sqlite3 db .dump

如果您只想导出选定的表，另请参见此信息.

See also this info if you want to export only selected tables.

这篇关于Java JDBC/SQLite:将表导出到sql语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！