You don't need a COLUMNS clause. It only changes insert statements from
INSERT INTO TBL VALUES (1, 2, 3) to INSERT INTO TBL (A, B, C) VALUES (1, 2,
3), it can be useful if you want to load the script into some other
database that don't support insert statements without names of columns.
I only
Good afternoon, I'm using the latest version of h2 1.4.199 and would like to
know if the command:
PreparedStatement statement = conn.prepareStatement
("SCRIPT COLUMNS TO?"); It works?
I only need a script with all my database inserts.
I tried passing the names of the tables I try to export
Sorry, I meant, I cannot replace the empty name, since it is empty in the
Confluence table that is used as the data source in this case, and I am not
necessarily the owner of this table.
On Thursday, August 8, 2019 at 7:01:48 PM UTC+3, George Ivanov wrote:
>
> I cannot use empty name, the empty
Is the same bug present in the latest H2 release?
On Thursday, August 8, 2019 at 7:01:48 PM UTC+3, George Ivanov wrote:
>
> I cannot use empty name, the empty value comes from Confluence page table
> where the header cell is empty
>
> On Thursday, August 8, 2019 at 3:41:55 PM UTC+3, Evgenij
Is it possible to run the script just updating the data, without dropping
all tables?
I can already backup and restore, I would just like to use UPDATE OR MERGE
in my schema
Em quinta-feira, 8 de agosto de 2019 11:40:16 UTC-3, Evgenij Ryazanov
escreveu:
>
> Hello.
>
> H2 can export a
Is it possible to run the script just updating the data, without dropping
all tables?
I can already backup and restore, I would just like to use UPDATE OR MERGE
in my schema.
Em quinta-feira, 8 de agosto de 2019 11:06:58 UTC-3, Bruno Santos Silva
escreveu:
>
> I am using the most current
I cannot use empty name, the empty value comes from Confluence page table
where the header cell is empty
On Thursday, August 8, 2019 at 3:41:55 PM UTC+3, Evgenij Ryazanov wrote:
>
> Hello.
>
> Yes, it looks like a bug. You can use some non-empty name of the last
> column as a workaround.
>
>
Hello.
H2 can export a database in two formats.
1. Regular backup (BACKUP TO 'filename.zip'). You can unpack the generated
archive and use it as a database.
2. Export format (SCRIPT TO 'filename.sql'). You can execute it in a new
empty database with RUNSCRIPT FROM 'filename.sql'.
So you need
Both lines have 3 columns, it's just a bug in Csv.readHeader() /
Csv.readValue().
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to
possibly we just need an error message when the number of columns in the first line does not match the number of columns
in the data rows
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails
I am using the most current version of h2 and I can create a backup via java
and restore data,
I would like to know if I can restore a backup only with the option to update
existing tables and columns is possible?
I'm using this command in java
PreparedStatement statement =
Hello.
Yes, it looks like a bug. You can use some non-empty name of the last
column as a workaround.
A,B,C
0, 1, 2
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
Hello!
I am trying to create a table using the following CSV file (test.csv):
===
,,
0,1,2
===
CREATE TABLE A AS SELECT * FROM CSVREAD('test.csv');
SELECT * FROM A
However, in the result I see that the third column (COLUMN2) gets lost:
[image: CSVREAD.png]
Could you please check?
Thank you,
13 matches
Mail list logo