Home >> MySql >> Insert query in MySql

Insert query in MySql

INSERT used for add new records in a table.

Syntax

1)-INSERT INTO tablename(column1,column2,column3,...)values(values1,values2,values3,...)

2)-INSERT INTO tablename SET column1=values1,column2=values2,column3=values3,...

3)-INSERT INTO tablename values(values1,values2,values3,...)

Post Your Comment

Next Questions
Select table
Where clause
AND Clause
OR Clause
Update query
Delete query
Like clause
IN clause
Order By
Group By
Distinct keyword
Sorting
Between
Having
Union
Union all
Exits
Not Exits
Any
All
Max
Min
Avg
Count
Sum

Copyright ©2022 coderraj.com. All Rights Reserved.