How To Insert Data In MySQL | INSERT STATEMENTS | MySQL Tutorial for Beginners in Hindi

preview_player
Показать описание
In this video, I've demonstrated how to insert data into the table. Data can be inserted into the table using the INSERT Statement.

The official way to pronounce “MySQL” is “My Ess Que Ell” (not “my sequel”), but we do not mind if you pronounce it as “my sequel” or in some other localized way.

************************************
Please watch the video till the end to get a better understanding. And If you found the video helpful then be sure to hit the like button.

Thanks for watching.
Check Out SQL In MySQL Playlist for the entire videos.
************************************

SQL INSERT statement is a SQL query. It is used to insert a single or a multiple records in a table.

There are two ways to insert data in a table:
1) By SQL insert into statement
i) By specifying column names
ii) Without specifying column names
2) By SQL insert into select statement

1) Inserting data directly into a table
You can insert a row in the table by using SQL INSERT INTO command.

There are two ways to insert values in a table.

In the first method, there is no need to specify the column name where the data will be inserted, you need only their values.

INSERT INTO table_name
VALUES (value1, value2, value3....);
The second method specifies both the column name and values which you want to insert.

INSERT INTO table_name (column1, column2, column3....)
VALUES (value1, value2, value3.....);

2) Inserting data through SELECT Statement
SQL INSERT INTO SELECT Syntax

INSERT INTO table_name
[(column1, column2, .... column)]
SELECT column1, column2, .... Column N
FROM table_name [WHERE condition];

************************************
Link for my other Videos:

MySQL Introduction for Beginners

MySQL File System vs DBMS

MySQL Server & MySQL Workbench Installation

Introduction to SQL

Creation of Database in MySQL

Table Creation in MySQL

Insertion of Data in MySQL

***************************************

CONNECT WITH ME 📲⌨

***************************************
#DataInsertion #InsertRecords
mysql for beginners
learn mysql
mysql course
learn sql
sql basics
database
data
sql course
sql crash course
structured query language
sql beginners
mysql crash course
sql tutorials for beginners
sql for beginners
mysql database tutorial
database tutorial
mysql database
mysql tutorial for beginners
sql tutorials for beginners in hindi
mysql tutorial for beginners in hindi
how to insert data into the table
how to insert multiple records into the table
insert statements in mysql database
insert data into table sql
insert data into table sql server
insert data into table sql server
dynamically insert data into table sql server
insert data into table type sql server
insert data into table mysql workbench
vidiv academy
Рекомендации по теме
join shbcf.ru