sql-insert Flashcards

1
Q

How do you add a row to a SQL table?

A

insert into table name(column), values ()

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

What is a tuple?

A

list of values (inside the parenthesis for 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

you add with more () and separate 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 clause.

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