sql-insert

Question 1

How do you add a row to a SQL table?

Answer 1

Insert into ‘’ (“column1, “column2”, “column3”) values (‘value1’, ‘value2’, value3);

Question 2

What is a tuple?

Answer 2

A list of values. Always a fixed size. It has a defined data type. It corresponds with a specific column. Each position can have a specific data type.

Question 3

How do you add multiple rows to a SQL table at once?

Answer 3

Data rows can be batch inserted into a database table by specifying more than one tuple of values, separated by commas. Below we are inserting tow new rows into the “products” table.

insert into “products” (“name”, “description”, “price”, “category”)
values (‘Ostrich Pillow’, ‘Feel comfy and cozy!’, 99, ‘self care’),
(‘Tater Mitts’, ‘Scrub some taters!’, 6, ‘cooking’)
returning *;

You can also insert one row at a time….
INSERT INTO “tableName”
SET “columnA” = ‘hi’,
“columnB” = ‘there’;