HSQL - insert into table with multiple values

Asked May 31 '21 at 18:37

Active May 31 '21 at 18:37

Viewed 261 times

There is a large HSQL-import-data.sql scripts. I lists all inserts which are required to fill the database with

INSERT INTO table (name, firstname) VALUES ('john', 'john);
INSERT INTO table (name, firstname) VALUES ('mark', 'mark);

I would prefer to rewrite it like for better readability

INSERT INTO table (name, firstname) VALUES 
                  ('john', 'john'),
                  ('mark', 'mark);

Unfortunaletly I do not know to achieve it with hsql. If I put the values all in one line it works, but then the script becomes not more readable. So how i mark that a statement continues on the next line. Just as an example in the bash world this would be the \character.

asked May 31 '21 at 18:37

EhmKah a.k.a. Michael Krauße

2,837
5
34
53

1

Are you using SqlTool.jar to import the script? – fredt May 31 '21 at 18:52
No - I am using it in a spring boot profile to have some local test-data. – EhmKah a.k.a. Michael Krauße Jun 01 '21 at 10:31
Thank you @fredt . your question helped me to find out that this is a hibernate issue not hsqldb issue. I found the solution that I have to reconfigure hibernate a bit with this answer https://stackoverflow.com/questions/32953037/spring-mvc-hibernate-encoding-multi-line-import-sql – EhmKah a.k.a. Michael Krauße Jun 01 '21 at 11:15

HSQL - insert into table with multiple values

0 Answers0