FirebirdSQL is a relational database management system that supports SQL and is known for its high performance and stability. It can run on multiple operating systems, including Windows, Linux, and macOS.
To connect to a FirebirdSQL database, you can use the isql command-line tool or a variety of client libraries that are available in multiple programming languages.
The following SQL statement creates a table named people with columns for id, name, age, and email.
CREATE TABLE people (
id INTEGER NOT NULL PRIMARY KEY,
name VARCHAR(100),
age INTEGER,
email VARCHAR(100)
);
The following SQL statement inserts a new row into the people table.
INSERT INTO people (id, name, age, email)
VALUES (1, 'John Doe', 30, '[email protected]');
The following SQL statement updates the age of a person with the id of 1.
UPDATE people
SET age = 31
WHERE id = 1;
The following SQL statement deletes a person with the id of 1.
DELETE FROM people
WHERE id = 1;
The following SQL statement retrieves all rows from the people table.
SELECT * FROM people;