1. SQL Insert Into Query
Syntax : Insert Into tablename (column1,column2, column3,........)
Values(value1,value2,value3,............)
Function: The Insert query is used to insert records in a database
Example: Insert Into Employees(Empid, EmpName, EmpAddress, Empphone)
Values(1,'Ana Johnson','New York', 12345676);
2. SQL Update Query :
Syntax: Update Tablename set column1 = value1, column2-=value2 ,
column3="value4" where condition ;
Function: The update query is used to modify a data in a database.
Example: Update Employees set EmpName="Sashank",
EmpAddress="Sweden" where Empid = 3;
3. SQL Delete Query:
Syntax: Delete from tablename where condition ;
Function: This query is used to delete a record of a table.
Example: Delete from Employee where EmpName="Ana Johnson";
