sql-insert Flashcards
1
Q
How do you add a row to a SQL table?
A
insert into “name of table to insert to” (“column names separated by commas”)
values (’text values wrapped in single quotes’, number values with literal numbers);
2
Q
What is a tuple?
A
In SQL, a list of values is referred to as a tuple.
3
Q
How do you add multiple rows to a SQL table at once?
A
Data rows can be batch inserted into a database table by specifying more than one tuple of values, separated by commas
4
Q
How do you get back the row being inserted into a table without a separate select statement?
A
returning * after the values