INSERT INTO table_name (Column1, Column2, Column3)
VALUES(1, 'Value2', 'Value3')
or
INSERT INTO table_name
SET
Column1 = 'Value1',
Column2 = 'Value2',
Column3 = 'Value3'
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.
0 Comments