17 | Create Database Tables in MySQL PHP Tutorial | 2023 | Learn PHP Full Course for Beginners

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

➤ GET ACCESS TO MY LESSON MATERIAL HERE!

First of all, thank you for all the support you have given me!

I am really glad to have such an awesome community on my channel. It motivates me to continue creating and uploading content! So thank you!

I am now using Patreon and YouTube Memberships to share improved and updated lesson material, and for a small fee you can access all the material either from my memberships or Patreon, depending on your preference. I have worked hard, and done my best to help you understand what I teach.

I hope you will find it helpful :)

[Dani_Krossing]

Hi everyone! Sorry about the long break 🙂 For people who check my community posts, you'll know that I have had to take care of Frida (my dog), who had been extremely sick for the past few weeks. Unfortunately she didn't make it, so I needed some time to deal with all that... But I'm back again now. 🙂

[ingelegenial]

You are underrated, Daniel. Thank you for everything.

[davescorneroftheworld]

Very sorry for your loss. I am not a dog lover but I have lost a few cats in my 73 years so I understand your pain.
THANK YOU FOR ALL YOU DO ON THIS TOPIC. I have learned so much from you.

[theSassySquatch]

Dani, you are awesome! You are a great teacher! Thank you for your videos!

[decall]

I am so sorry to hear about your dog. We recently lost a cat and almost also our dog (but he went well fortunately). I love your lessons... Learned a lot of it...

[UHDking]

Thanks for the freshest mySQL tut from the god of programming tuts(the best one was New Boston but he does not make any tuts anymore for a long time and this is a fresh vs his 2013). Love your tuts Dani and thanks for your time. You are the best on YouTube.

[akashgola]

Sorry to hear about Frida. Hopefully ur over it now. The video was amazing as always. Also what i am liking the most is the logics or practicality inside ur videos. Great Work Keep going🔥

[jackiedavis]

You are just the best!! Amazing delivery, simple logical explanation - you have freed me from my exasperation with my websites! Been looking for way to learn to do logins and comments on my site. (I hate those non-verbal, canned music, no explanation videos) but you are phenomenal! Forget binging tv shows, I am binging your tutorials!! Thank you so much! - and I am so sorry about your pup :(

[samnako]

I'm glad this video is out now when i am trying to design a new website and I will definitely pick one or two knowledge to add to what I'm doing right now.

Thank you Daniel

[Killer-keff]

Man you're a savior I have a web development course and you are saving me time and I actually understand you well Thanks for your efforts

[ArgieHista]

Here I am again... Watching your videos and learning for something that no one can taught me easily but You... Thank you for sharing your knowledge.. Godblessed 🙏

[andymalunes]

damn, many people just straight to this one, im new to programming and php but i noticed the views jump up for this specific lesson.

[renatusrichard]

Thank you so much sir, have enjoyed the lesson

[nisanka]

Dani Krossing deserves 1 Million subscribers

[omarghabawi]

Hi, I followed your instruction and encountered an error. The database did not accept CURRENT_TIME; instead, it accepted CURRENT_TIMESTAMP. Is there a different syntax to resolve this error? I am also using phpMyAdmin like you. Thank you!

[armandoWebDev]

Daniel, correct me if I'm wrong, but I read that VARCHAR has tha capability to take a VARIABLE amount of memory, so if we define (30) characters this doesn't mean that will reserve that space in memory, it is just the maximum amount of memory/characters can take in one spot but if you store let's say, 10 characters in a VARCHAR(30) will just consume 10 characters space in memory. Hope my idea is clear. Thank you for your course.!

[noelradhakrishnan]

I have a doubt though, shouldn't we refer the username from the users table as a foreign key to the comments table?

[fotonext]

FOREIGN KEY REFERENCES must be PRIMARY KEY in the parent table, or can it be any column?

[uggrnes]

Maybe we have several IDs in the users table. On what basis does the database value users_id?

[TOMAKAIROS]

im getting this error....

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURRENT_TIME,
PRIMARY KEY (id)
)' at line 6

is my version too new??? or is it too old? how do i check the version?