SQL – Interpret and modify
No description yet. This curated deck is ready for daily study.
Card preview (12)
What does SQL stand for?
Structured Query Language
What does the SELECT statement do?
SELECT statement is used to collect fields from a given table
What does the SELECT * statement do?
SELECT * specify that the query should return all columns of the queried tables
What does the FROM statement do?
Can be paired with the SELECT statement to specify which table(s) the information will come from
What does the WHERE statement do?
The WHERE statement can be used in conjunction to specify the search criteria
What does ORDER BY statement do?
The ORDER BY part of the code specifies whether you want it in ascending or descending order (values are automatically placed in ascending order)
What does the ORDER BY ____ Desc statement do?
Adding ‘Desc’ to the end of statement will cause values to be displayed in descending order
What does the JOIN statement do?
JOIN provides a method of combining rows from multiple tables based on a common field between them
What does the CREATE statement do?
The CREATE function allows you to make new databases
What does the ALTER statement do?
ALTER is used to add, delete or modify the columns in a table
What does the INSERT INTO statement do?
This is used to insert a new record into a database table
What does the DELETE statement do?
Used to delete a record from a database table