How to add a series of data in a table?

Question

I need to add a series of data from 0 to 1000 in a column of a table in LibreOffice Base and I would like to find a way with a SQL command instead to insert all 1000 one by one. Is it possible to do or not?

Which LibreOffice version? They changed the embedded database from HSQLDB to Firebird and the answer will depend on which one you use — , Oct 16 '19 at 08:09

fredt · Answer 1 · 2019-10-17T11:49:43.313

The version of HSQLDB (1.8.0) traditionally supplied with LibreOffice and OpenOfficeOrg is now over 10 years old and does not support advanced features. You can use the "split database" solution in order to use a recent version (2.4.x or 2.5.x) of HSQLDB. This has been documented at length here:

https://forum.openoffice.org/en/forum/viewtopic.php?f=83&t=61183

With the recent versions of HSQLDB, you can insert values from the SEQUENCE_ARRAY function. In the following example, a table that has one column is populated with values (0, 1000):

CREATE TABLE T (ID INT);
INSERT INTO T (SELECT * FROM UNNEST( SEQUENCE_ARRAY(0, 1000, 1)) );

The SEQUENCE_ARRAY function is documented here:

http://hsqldb.org/doc/2.0/guide/builtinfunctions-chapt.html#bfc_array_functions

How to add a series of data in a table?

1 Answers1