sql-insert Flashcards
1
Q
How do you add a row to a SQL table?
A
INSERT INTO “tableName” (“nameOfValue”)
VALUES (‘valueData’)
2
Q
What is a tuple?
A
a tuple is a list of values
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
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