Welcome

For the MySQL Tutorial, I watched several Youtube videos produced by a guy named Bucky. These videos covered every single topic of basic Standard Query Language. Everything from adding rows to advanced filtering methods and functions.


Select

Select

In this picture you can see an example of just using the Select statement to gather ID,name, and city from the customer table.


WHERE

where

In this picture you can see an example of just using WHERE statement where the ID was 1 or 2 AND the city was Raleigh.


ORDER

Order

In this picture you can see an example of just using ORDER statement where i Selected name,city,state, zip from Customers and Ordered by the ID in DESCENDING ORDER. Do note that ID was not selected but you can still order by it.


INSERT

Insert

In this picture you can see an example of just using the INSERT statement which inserted values into ITEMS into the id, name, cost, seller ID, and bids cost and there Values were 104 for ID, Beef chops for name, 7.99 for cost, 1 for seller ID and 0 for Bids