Skip to content

Instantly share code, notes, and snippets.

@gmyrianthous

gmyrianthous/insert_rows.sql

Last active September 4, 2022 14:00
Show Gist options
  • Save gmyrianthous/d613227347443a177bfe35cde4fc08af to your computer and use it in GitHub Desktop.
Save gmyrianthous/d613227347443a177bfe35cde4fc08af to your computer and use it in GitHub Desktop.
Download ZIP
Add sample rows in rental table
Raw
insert_rows.sql
INSERT INTO rental VALUES (1, 100, 4, 12.49, 'completed', NULL, '2021-05-01 12:45:39'::timestamp, '2021-05-03 15:10:02'::timestamp)
INSERT INTO rental VALUES (3, 100, 4, 5.68, 'on_rental', NULL, '2022-10-01 12:45:39'::timestamp, NULL)
INSERT INTO rental VALUES (3, 100, 4, 5.68, 'on_rental', NULL, '2022-10-01 12:45:39'::timestamp, NULL)
INSERT INTO rental VALUES (4, 100, 4, 1.67, 'completed', NULL, '2022-09-01 08:21:32'::timestamp, '2022-09-02 09:21:22'::timestamp)
INSERT INTO rental VALUES (5, 100, 6, 2.67, 'completed', NULL, '2022-05-01 08:21:32'::timestamp, '2022-05-02 09:21:22'::timestamp)
INSERT INTO rental VALUES (6, 100, 6, 0.49, 'completed', NULL, '2022-05-03 08:21:32'::timestamp, '2022-05-04 09:21:22'::timestamp)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment