Search code snippets, questions, articles...

Insert data into table mysql query

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.

Was this helpful?
0 Comments