To get insert statement like INSERT INTO TBL (A, B, C) VALUES (1, 2, 3),
what command I have to use?
On Friday, August 9, 2019 at 7:24:48 AM UTC+5:30 Evgenij Ryazanov wrote:
> You don't need a COLUMNS clause. It only changes insert statements from
> INSERT INTO TBL VALUES (1, 2, 3) to INSERT
How can I use COLUMN option in SCRIPT.
I'm not able to figure this
java -classpath h2-1.4.199.jar org.h2.tools.Script -url
"jdbc:h2:file:C:\test_db" -user sa -password "" -script "backup.sql"
-options COLUMNS
Exception in thread "main" org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax
error in
Is there any other option to retrieve the INSERT statement with column
names using the above tool?
On Monday, September 26, 2022 at 9:05:29 PM UTC+5:30 Evgenij Ryazanov wrote:
> Hello!
>
> Unfortunately, this tool doesn't support all clauses of the SCRIPT
> command. You need to use the Shell