Insert data into table mysql query

sql Share on :

INSERT INTO table_name (Column1, Column2, Column3)
VALUES(1, 'Value2', 'Value3')

or

INSERT INTO table_name
SET
Column1 = 'Value1',
Column2 = 'Value2',
Column3 = 'Value3'

Best JSON Validator, JSON Tree Viewer, JSON Beautifier at same place. Check how cool is the tool

INSERT query in MYSQL is used to fill data into table columns as a row. You can define column names into the query or you can directly insert data using 'VALUES'. An easy way is also to use 'SET' and assign values to its column directly.

Contribute to this Snippet

Was this helpful?

Created by :

@

Write your Comment

0 Comments

Similar code snippets

Insert data from one table to another in MySql
MSSQL query to insert value which contains apostrophe or single quote
Fetch all data from table SQL
Drop table SQL query
Truncate table SQL query
Delete from table SQL query
UPDATE TABLE SQL query

Create your own code snippets and search them using our portal and chrome extension

Programming Feeds

Learn something new everyday on Devsheet

Important Links

Join Devsheet Create new snippet Ask a Question Write an article Online JSON Viewer