how to insert these records into a dbeaver app?

Question

INFO:

INSERT INTO department VALUES ('R and D', 1, 123456789, '2014-07-14');

INSERT INTO department VALUES ('Finance', 2, 123456783, '2016-02-07');

INSERT INTO department (department_id, department_name, SSN_manager, manager_start_date) VALUES (3, 'Marketing', 123456788, '2012-04-21');

INSERT INTO department (department_id, department_name) VALUES (4, 'Human Resources');

Answer 1

To insert records into a DBeaver app, open up the app and select the database you want to work with. Then, open the SQL editor, type in each INSERT statement above, and run the query. For example:

INSERT INTO department VALUES ('R and D', 1, 123456789, '2014-07-14');

INSERT INTO department VALUES ('Finance', 2, 123456783, '2016-02-07'); 

INSERT INTO department (department_id, department_name, SSN_manager, manager_start_date) VALUES (3, 'Marketing', 123456788, '2012-04-21');

INSERT INTO department (department_id, department_name) VALUES (4, 'Human Resources');

Then, click the Execute button to run the query and insert the records into the database.