How to Insert Into Table in SQL | SQL Class Day #09 In Telugu
This Short is About SQL Class Day #09 (SQL series) in Telugu for SQL Developers, Data Analyst and Business Analyst. By Srinivas Reddy Excel Telugu Videos
How to Insert the rows Into a Table in SQL Server.
DML (Data Manipulation Language):
---------------------------------------------
INSERT
DELETE
UPDATE
DQL (Data Query Language):
--------------
SELECT
Insert Command:
----------------------
The INSERT Command is used to add rows to a table. If we are entering table data then it is optional to specify the column list. where as if we are entering only particular column details or the order of columns then we must specify the column list.
INSERT INTO EMP(EID,ENAME,SAL) VALUES (101,'SRINIVAS',25000);
OR
INSERT INTO EMP VALUES (102,'VEERU',35000);
SELECT *FROM EMP;
If we want to insert only certain columns data into the table, the column names have to be specified.
INSERT INTO EMP(EID,SAL) VALUES (103,15000);
-To insert multiple records
INSERT INTO EMP VALUES(103,'MOUNIKA',40000),
(104,'PARAMESH',22000),
(105,'NIHAR',45000),
(106,'ABC',43000)
#sql #excel #shorts #telugu #excelteluguvideos #mysql #sqltelugu
Please Follow us on Instagram: / excelteluguvideos
Telegram: https://t.me/EXCELTELUGUVIDEOS