What version of MySQL are you using?

Answer: Version 5.5.24

What SQL command is used to make a new database? What command is used to make a new table in a database?

To make a new database use the command CREATE DATABASE database_name;.
To make a new table in a database use the command CREATE TABLE tablename (column 1name description, column2name description,...);

What SQL command is used to select the database with which you want to work?

The USE command.

What SQL commands are used for adding records to a table? HINT: There are multiple options.

The INSERT command can be used in different methods either naming the columns to be populated or by including values for every column.
The command UPDATE may also be used to update a columns value.

What types of values must be quoted in queries? What types of values shouldn't be quoted?

String values, date and time values must be quoted.
Numeric values shouldn't be quoted. Functions cannot be quoted and NULL must not be quoted.

What does the asterisk in SELECT * FROM tablename mean? How do you restrict which columns are returned by a query?

The asterisk (*) means you want to retrieve every column.
To restrict which columns are returned by the query you must specify the columns to be returned separated by a comma.

What does the NOW() function do?

The NOW() returns the current Date and time on the server.

How do you restrict which rows are returned by a query?

By using the conditionals with the SQL term WHERE.

How do LIKE and NOT LIKE differ from simple equality comparisons? Which type of comparison will be faster? What are the two LIKE and NOT LIKE wildcard characters?

LIKE and NOT LIKE deal primarily with strings and allow for a more flexible condition.
Equality comparisons are faster because LIKE and NOT LIKE cannot take advantage of indexes.
The two wildcard characters are underscore (_) and %.

How do you affect the sorting of returned records? What is the default sorting method? How do you inverse the sort? What is the syntax for sorting by multiple columns?

By using the ORDER BY clause.
The default sorting method is a meaningless order.(When using the ORDER BY clause the default order is ascending.)
To inverse the sort you can specify a descending order with DESC.
SELECT column1, column2 FROM tablename ORDER BY column2, column1;

What does the LIMIT clause do? How does LIMIT x differ from LIMIT x, y?

The LIMIT clause states how many records you want returned.
LIMIT x will return X amount of records. LIMIT x, y will return y number of records starting at x.

What SQL command is used to change the values already stored in a table? How do you change multiple columns at once? How do you restrict to which rows the changes are applied?

The SQL command used to change the values already stored in a table is SET.
You can change multiple columns at once by separating them with commas.
You can restrict which rows the changes are applied to using the conditional WHERE.

What SQL command is used to delete rows stored in a table? How do you restrict to which rows the deletions are applied?

Use the SQL command DELETE.
You restrict to which rows the DELETE is applied using a conditional WHERE and for extra safety use a LIMIT clause. Once information is deleted it cannot be retrieved unless you have backed up your database!

What is an SQL Alias? How do you create one? Why is an alias useful?

An SQL alias isa symbolic renaming of an item used in a query normally applied to tables, columns, or function calls.
An alias is created by adding the term AS aliasname after the item to be renamed.
An alias is useful because it will be used as a new title for the returned data and can also be used in other functions further down the SQL command.