sql-insert

Question 1

How do you add a row to a SQL table?

Answer 1

Insert into “table name” (“list”, “of”, “columns”)
Values (‘list’, ‘of’, ‘values’)
(for values: text in single quotes, numbers no quotes)

Question 2

What is a tuple?

Answer 2

A tuple is a list of values

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

Question 4

How do you get back the row being inserted into a table without a separate select statement?

Answer 4

returning followed by * or “column name(s)”