During this assignment I was required to watch and follow along with some short tutorial videos. The videos were designed to teach viewers about creating and manipulating databases using MySQL. Please see below for more information.
Using show command to display databases. Using Show command to display columns within a database. Here I used the select command to show only the columns I wanted. Each column name is separated by a ",". Using the ORDER BY command to sort data in this case descending(DESC).
Show using the "%" wildcard wich can be used for zero, one, or multiple characters. You could also use "_" to represent a single unknown character. Using CONCAT() functoin to join columns together. Also useing keyword AS to rename the custom column. This illustrates the use of the key word “IN” to replace multiple “OR”. Using REGEXP Limiting the number of returned records.
Here you will see the ability to use multiple functions in the same statement. Here I created a view that displays data from tables. This image demonstrates useing a full text search with the bool option. This image demonstrates the ability to do math within the query. Here I have joined information from two separate tables. Using DISTINCT command to show only unique entries.
