SQL insert Flashcards

1
Q

How do you add a row to a SQL table?

A

insert into

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

use a comma for the values portion

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

returning *;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly