sql-insert Flashcards

1
Q

How do you add a row to a SQL table?

A

INSERT INTO “tableName” (“nameOfValue”)
VALUES (‘valueData’)

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

What is a tuple?

A

a tuple is 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

VALUES (‘valueData’), (‘valueData2’)

aka a comma seperated list of tuples

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 specified column names

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