The "INSERT
INTO" statement is used to insert
new records or data in a table.
Syntax of Insert Into Command:
INSERT INTO table_Name
VALUES(value1,value2,value3,...)
OR
INSERT INTO table_Name (column1,column2,column3,...)VALUES (value1,value2,value3,...)
Insert into Employee
values(1,'AAA','Delhi','8147280584')
Insert into Employee
values(1,'BBB','Moradabad','9999999999')
Insert into Employee
values(1,'CCC','Bangalore','8147280584')
Insert into Employee
values(1,'DDD','Noida','8147280584')
Insert into Employee
values(1,'EEE','Haridwar','9927153056')
INSERT INTO table_Name
VALUES(value1,value2,value3,...)
OR
INSERT INTO table_Name (column1,column2,column3,...)VALUES (value1,value2,value3,...)
Insert into Employee
values(1,'AAA','Delhi','8147280584')
Insert into Employee
values(1,'BBB','Moradabad','9999999999')
Insert into Employee
values(1,'CCC','Bangalore','8147280584')
Insert into Employee
values(1,'DDD','Noida','8147280584')
Insert into Employee
values(1,'EEE','Haridwar','9927153056')
Now
after inserting the data into table how will see or select data from database.
we will use a Select Command like below
Select * from Employee
After executing this command data will display like below image
Select * from Employee
After executing this command data will display like below image
No comments :
Post a Comment