For the last video in this series, I learned how to join two tables together with cross joins, inner joins, and outer joins. Exciting stuff here! (And I don’t mean that sarcastically. Learning about joins opens up a whole new world of database possibilities!) Anyway, this video is five and a half minutes long.
This nine-minute video covers a lot. To add deadlines and recurring tasks to my to-do list, I had to learn about MySQL’s date functions, operators, null values, the UPDATE statement, and the CASE control flow function.
Eight-and-a-half-minute video. Today I learned how to delete rows from a table in MySQL using an HTML form with dynamically generated checkboxes. To do so, I had to learn about a bunch of stuff like primary keys and some new MySQL statements.
A three-minute video on how to select and display data from MySQL.
This six-minute video shows how I created a table and then inserted data from an HTML form into MySQL.
This seven-minute video shows how I used PHP to connect to a MySQL database — well, after reading about some functions and getting familiar with phpMyAdmin.
MySQL is an open source database management system. (Say that ten times fast!) Since it’s so popular and it works so well with PHP, I’d be crazy not to learn how to use it! So here’s what I’ve learned so far.
Get notified of every new tutorial as soon as it's posted! Subscribe via RSS or via email:
MySQL is a database management system. So far I’ve learned how to use it with PHP by making My First PHP/MySQL Project, which I covered in a video series.