sql-insert Flashcards

1
Q

How do you add a row to a SQL table?

A

insert

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

What is a tuple?

A

A list of values

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

add multiple tuples after the values keyword, all separated by commas

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 *;

or specific column names in place of *

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