Create Base Table with Values

[flywire]

What is the most efficient way of creating a sample table in Base?

I understand INSERT INTO ... VALUES will only add one record to base (HSQLDB V1.8). If no Field_name is specified, all fields must be completed and in the right order (as laid down in the table). That includes the automatically incremented primary key field, where present. eg:

CREATE TABLE "Employees" (
"ID" INT PRIMARY KEY,
"FirstName" VARCHAR(50),
"Position" VARCHAR(50)
);
 
INSERT INTO "Employees"
VALUES
('0', 'Kate', 'Nurse');
 
INSERT INTO "Employees"
VALUES
('1', 'Paul', 'Family Therapist');
 
INSERT INTO "Employees"
VALUES
('2', 'Kaitlin', 'Manager');

-- Insert further records

Edit: I’m thinking sql = but I’m wondering if there’s something more efficient.

[Villeroy]

‘1’ is character 1. Simply write 1 if you mean number 1.
I would always declare such ID as IDENTITY (auto-ID).

CREATE TABLE "Employees" (
"ID" INT IDENTITY,
"FirstName" VARCHAR(50),
"Position" VARCHAR(50)
);
 
INSERT INTO "Employees"
VALUES
(NULL, 'Kate', 'Nurse');

Finally menu:View > Refresh Tables