SQL insert Flashcards

1
Q

How do you add a row to a SQL table?

A

Insert into (column names)

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

What is a tuple?

A

value name in parathesis

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

you can add another ( ) (tuple) set

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