SQLite Editor

CREATE TABLE IF NOT EXISTS positions (
	id integer PRIMARY KEY,
	title text NOT NULL,
	min_salary numeric
);

INSERT INTO positions (title, min_salary)
VALUES ('DBA', 120000),
       ('Developer', 100000),
       ('Architect', 150000);

SELECT
	id,title,min_salary
FROM
	positions;

CREATE UNIQUE INDEX idx_positions_title ON positions (title);

REPLACE INTO positions (title, min_salary)
VALUES
	('Full Stack Developer', 140000);

SELECT
	id,title,min_salary
FROM
	positions;

REPLACE INTO positions (title, min_salary)
VALUES
	('DBA', 170000);

REPLACE INTO positions (id, min_salary)
VALUES
	(2, 110000);

Dark Mode

Enter a query, then click the execute button or press F9 to run it.