SQL

Question 1

What is SELECT’s function

Answer 1

To return data, it requires SELECT and then the feild name, FROM which is the table, WHERE which is which row(s) you want to access.

Question 2

What is WHERE’s purpose?

Answer 2

To limit the results down to what you want, e.g. WHERE PrimaryKey = x when you want a specific items details

Question 3

what is FROM’s purpose?

Answer 3

To identify which table you want to access this data from

Question 4

What is AND’s purpose?

Answer 4

To add another requirement to the queary and its part of the where function

Question 5

What is UPDATES function?

Answer 5

To update data, it requires UPDATE which acts like the FROM, SET which is what you are doing to the data, and WHERE which is where the data you want change is

Question 6

What is DELETE’s function

Answer 6

To delete a row of data, it requires DELETE FROM which acts like the FROM, and WHERE which is where you want the data to be deleted

Question 7

What is inserts function?

Answer 7

To add data to a table, it requires INSERT INTO which is then followed by the table name like a FROM, and then VALUES and then the data you want adding.

Question 8

How do you create a table

Answer 8

CREATE TABLE (tableName)(
(fieldName) (dataType)
PRIMARY KEY (fieldName)
)

Question 9

How do you use ORDER BY

Answer 9

slap it on the end of a queary e.g. ORDER BY (fieldName) ASC -for ascending or DESC for decending-