Learn SQL The Hard Way – Flashcards
Unlock all answers in this set
Unlock answersquestion
Create
answer
Putting data into tables
question
Read
answer
Query data out of the table.
question
Update
answer
Change data already in the table.
question
Delete
answer
Remove data from the table.subl
question
.quit
answer
Quit the command line interface
question
integer
answer
Create a column with the integer data type
question
primary key
answer
Identify a column as a primary key
question
text
answer
Create a column with the text data type
question
create table
answer
Create a new table
question
insert into
answer
Insert data into a table
question
values
answer
Specify the values you want to insert into a table
question
select
answer
Read data from a table
question
where
answer
Specify conditions about the data you want to retrieve from the table
