Learn how to create database tables in MySQL using PHP! This video is perfect for beginners who want to learn the basics of PHP database programming.

In this video, you will learn:

  • How to connect to a MySQL database in PHP
  • How to create a database table
  • How to add columns to a table
  • How to set the properties of a column
  • How to insert data into a table

By the end of this video, you will be able to confidently create and manage database tables in MySQL using PHP!

In this PHP tutorial I will talk about how to create a MySQL database table, so we can insert data into our newly created database! šŸ™‚ This will be a lon lesson, and I will have chapters bellow the video for easy navigation. šŸ˜‰

I will cover MySQL tables, including data types, primary keys, foreign keys, and table relationships. šŸ™‚ So there is quite a bit to learn in this video.

āž¤ TIMESTAMPS

00:00:00 - Introduction to tables
00:04:02 - SQL data types
00:15:42 - SQL SIGNED & UNSIGNED 
00:17:20 - Creating our first table
00:26:48 - SQL PRIMARY KEY
00:29:58 - Creating our second table
00:32:28 - SQL FOREIGN KEY
00:35:56 - SQL ON DELETE

#mysql #php 

Learn how to create database tables in MySQL using PHP
1.05 GEEK