How to create Database in MySQL & How to create Table in MySQL?
In order to create databases & tables effectively, we must understand database concepts. Here in this video tutorial, we will understand, How to create Database in MySQL. And, How to create Table in MySQL.
In order to follow along with this tutorial, you should have MySQL installed on your computer. If you don't have MySQL, checkout my previous MySQL installation videos.
If you understood the explanation with examples, try your own examples on your computer. Let me know if you encounter any issue. I'll do my best to respond to your queries ASAP. Subscribe to my channel. And like and share this video.
Chapters #
0:00 Introduction
0:43 Four important SQL statements related to databases
01:55 List all database in MySQL server (SHOW DATABASES statement)
02:19 List all database in MySQL server (CREATE DATABASE statement)
03:02 Naming Conventions for Database Objects
05:25 Delete databases from MySQL database (DROP DATABASE statement)
06:26 Four important SQL statements related to database tables
07:54 Select MySQL database (USE statement)
08:45 Create a new database table in MySQL (CREATE TABLE statement)
11:14 List all tables in MySQL DB (SHOW TABLES statement)
11:35 Display MySQL table information (DESCRIBE TABLE statement)
11:55 Delete a table from MySQL database (DELETE TABLE statement)
12:23 End message, try yourself, ask question
#MySQL #Database #Table #Create