SQL insert Flashcards
1
Q
How do you add a row to a SQL table?
A
insert into
2
Q
What is a tuple?
A
values being inserted are also wrapped in () in parenthesis in the same order as the columns they belong to.
3
Q
How do you add multiple rows to a SQL table at once?
A
use a comma for the values portion
4
Q
How do you get back the row being inserted into a table without a separate select statement?
A
returning *;