In this Tutorial, Bucky Roberts leads us through a video based lesson on the basics of using the mySQL language for managing tables and databases. Bucky explains most of the basic commands, such as:
- SELECT - exctracts data from the database
- FROM - denotes where the extracted data is coming from
- WHERE - used to filter records and specify certain conditions
- UPDATE - updates data in the Database
The tutorial itself is very straightforward. Bucky starts off by explaining the basics of databases, and how they contain tables, which in themselves may contain website data on user information, passwords, video content, etc. Once the basic information of databases is established, we create our database.
The initial creation of my customers database.
Once the database has been created, and the customers.sql file from Bucky's website has been uploaded to the database, the data generated in the table will be available for use, as shown above.
------------------------------------------------------------------------------------
Another example I wanted to show, was some of the mySQL code in action. The above screenshots were taken from a scenario in one of Bucky's videos where Police were trying to narrow down murder suspects from 3 specific states, California, North Carolina, and New York. In the first screenshot, you can see the code reads "SELECT name, state FROM customers WHERE state='CA' OR state='NC' OR state='NY' ". It reads very logically, as this Selects names and states from the customers table, where the state either matches with California, North Carolina, or New York. The point Bucky was trying to make with all this, is that you can do the same thing, but with shorter syntax, as shown in the 2nd screenshot, where the "OR" statements have been replaced with the "IN()" method. This stood out to me as something that would be very helpful, if you had a long list of "OR" variables to go through.
Click here to go visit my Module 3!