MySQL Tutorial for Beginners - 1 - Creating a Database and adding a Table in it

Опубликовано: 05 Октябрь 2024
на канале: Ocean of Code

744

Hello Friends,
In today's video, we will get to learn how to ceate a database and how to add tables into it. I have explained every single step while doing so.

Please subscribe this channel, so that you will not miss any videos in future:
   / @oceanofcode

SQL commands used in this video with its timestamps:
==========================================
1. 03:25 show databases; // For listing all the databases present in our database
2. 03:41 create database google // Creating new database with google name
3. 04:40 use google; // For entering into a database named google
4. 05:28 show tables; // For listing all the tables present in selected database
5. 05:48 create table employees(id int(11) unsigned auto_increment primary key not null, name varchar(25), email varchar(25), hometown varchar(20)); // For creating table with name employees and 4 Fields
6. 09:54 describe employees; // For checking table structure of table employees
==========================================

XAMPP Download Link for All OSes:
https://www.apachefriends.org/downloa...

More Videos of this channel:
==========================================
What is VLOOKUP in Excel? in Simple words..
   • What is VLOOKUP in Excel? in Simple w...

MySQL Tutorial for Beginners - 1 - Creating a Database and adding a Table in it
   • MySQL Tutorial for Beginners - 1 - Cr...

MySQL Tutorial for Beginners - 2 - Inserting data into table
   • MySQL Tutorial for Beginners - 2 - In...

MySQL Tutorial for Beginners - 3 - Select data from table and Update data of the table
   • MySQL Tutorial for Beginners - 3 - Se...

MySQL Tutorial for Beginners - 4 - Deletion, Alteration, Renaming of Database and its Tables PART-I
   • MySQL Tutorial for Beginners - 4 - De...

MySQL Tutorial for Beginners - 5 - Deletion, Alteration, Renaming of Database and its Tables PART-II
   • MySQL Tutorial for Beginners - 5 - De...

MySQL Tutorial for Beginners - 6 - What is Foreign key and how to create it including IMP concepts
   • MySQL Tutorial for Beginners - 6 - Wh...

MySQL Tutorial for Beginners - 7 - What is INNER JOIN? (on two tables and three tables)
   • MySQL Tutorial for Beginners - 7 - Wh...

MySQL Tutorial for Beginners - 8 - What is LEFT OUTER JOIN? (Also called as LEFT JOIN)
   • MySQL Tutorial for Beginners - 8 - Wh...

MySQL Tutorial for Beginners - 9 - What is RIGHT OUTER JOIN? (Also called as RIGHT JOIN)
   • MySQL Tutorial for Beginners - 9 - Wh...

MySQL Tutorial for Beginners - 10 - What is FULL OUTER JOIN? (Also called as FULL JOIN)
   • MySQL Tutorial for Beginners - 10 - W...

Learn 20 Basic but Important Commands Of Linux Terminal in just 20 minutes
   • Learn 20 Basic but Important Commands...

How to write a Regular Expression for an Email-ID and a Mobile Number
   • How to write a Regular Expression for...

How to write Regular Expression for IPv4 and IPv6 IP addresses
   • How to write Regular Expression for I...
==========================================

Checkout my second channel on youtube for General Queries on WhatsApp etc. and its videos:
   / @aadityakavthekar
==========================================
How to Download WhatsApp Status?
   • How to Download WhatsApp Status?

How to Disable WhatsApp Blue Ticks feature for Read Messages?
   • How to Disable WhatsApp Blue Ticks fe...

How to Prevent People from adding YOU in their WhatsApp Groups without your Permission?
   • How to Prevent People from adding YOU...

Learn How to Upload a video on YouTube within just 5 minutes
   • Learn How to Upload a video on YouTub...

How to type in Marathi, Hindi, Telugu etc with English Keyboard in our Mobile?
   • How to type in Marathi, Hindi, Telugu...

How to delete paytm account permanently in English?
   • How to delete paytm account permanent...
==========================================

You can follow me on Quora:
https://www.quora.com/profile/Aaditya...

LinkedIn:
  / aaditya-kavthekar-03a64b48

Facebook Page Link for latest updates:
  / ocean-of-code-112216190150036

#primaryKeyMysql #Database #CreateTable #ComputerScience #DBMS #Tutorial