MySQL: INSERT INTO Statement

When you wanna insert some records into a table after its initial creation then the INSERT INTO statement is the go for you in MYSQL. INSERT INTO is basically used to insert some values or records into a table that has nothing in it.

Syntax

INSERT INTO TableName(Column1,Column2,Column3) VALUES(Value1,Value2,Value3)

Example

INSERT INTO crypto_price(ID, Name, Price) VALUES(1, 'ShibaInu', 76);

As we can witness here I have added some values into this table which has nothing before. So this is the way INSERT INTO works.