Skip navigation

Creating a database table

Creating a database table: PHP with MySQL Essential Training (2013)
Creating a database table: PHP with MySQL Essential Training (2013)

Database tables hold data associated with your website. MySQL has basic commands for working with database tables including SHOW TABLES, CREATE TABLE, SHOW COLUMNS FROM and DROP TABLE. This video presents best practices for creating a database table such as always providing an id column, dealing with nulls, setting auto increment columns and creating keys.

Resume Transcript Auto-Scroll
Skill Level Beginner
14h 32m
Duration
5,723,545
Views
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