Skip navigation

Populating a MySQL database

Populating a MySQL database: PHP with MySQL Essential Training (2013)
Populating a MySQL database: PHP with MySQL Essential Training (2013)

There are many methods for populating a MySQL database. This video demonstrates a simple manual method to insert rows, with attention to how to insert data when autoincrement columns are present, the use of single quotes, and entering integer, string and Boolean values into your table.You will also see examples of statements for selecting and displaying your data, as well as pitfalls to avoid when updating or deleting data.

Resume Transcript Auto-Scroll
Skill Level Beginner
14h 32m
Show More Show Less

Q: This course was revised on 6/4/2013. What changed?

A: The old version of this course was 6 years old and it was time for a complete revision, using PHP 5.4. (The tutorials will work with any version of PHP and covers any differences you might encounter). The author has also added updated installation instructions for Mac OS X Mountain Lion and Windows 8. The topics and end project are the same, but the code is slightly different. It also addresses frequently asked questions from the previous version.

Q: This course was updated on 5/20/2015. What changed?

A: We added one movie called "Changing the document root in Yosemite," which helps the Mac installation run more smoothly.

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now