SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE tags ( id serial PRIMARY KEY, title varchar NOT NULL, color varchar NOT NULL ); INSERT INTO tags (title, color) VALUES ('Бытовуха', '#4287f5'), ('Еденичка', '#444'), ('По выходным', '#f542cb'), ('Спорт', '#f5bc42'), ('Привычка', '#f57842'); CREATE TABLE tasks ( id serial PRIMARY KEY, title character varying NOT NULL, score integer NOT NULL ); INSERT INTO tasks (title, score) VALUES ('Помыть посуду', 1), ('Помыть пол', 5), ('Сделать упражнения', 3), ('Спорт', 15); CREATE TABLE tags_tasks ( tag_id int REFERENCES tags(id) ON UPDATE CASCADE ON DELETE CASCADE, task_id int REFERENCES tasks(id) ON UPDATE CASCADE ON DELETE CASCADE ); INSERT INTO tags_tasks (tag_id, task_id) VALUES (1, 1), (1, 2), (2, 1), (3, 2), (3, 3), (4, 3); SELECT * FROM tags_tasks RIGHT JOIN tasks ON tasks.id = tags_tasks.task_id WHERE tags_tasks.tag_id = 1;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear