INSERT INTO command is used to add new record into the table.
there is two way to insert a record into the table.
1) If you want to insert records in all fields(columns) then do not need defines the columns.
Syntax:-
INSERT INTO table_name values(value_1,value_2,value_3,value_4....value_n)
Example:-
INSERT INTO employees values(1,"Virat","Kohli","virat@abc.com","delhi")
Now check the new record is saved into employees table
SELECT * FROM employees
Output:-
+----+------------+-----------+----------------+------------+ | id | first_name | last_name | email | address | +----+------------+-----------+----------------+------------+ | 1 | Virat | Kohli | virat@abc.com | delhi | +----+------------+-----------+----------------+------------+
2) If you want to insert records in some fields (columns) then it should be defined.
Syntax:-
INSERT INTO table_name(column_1,column_2,column_3) values(value_1,value_2,value_3)
Example:-
INSERT INTO employees("id","first_name","email") values(2,"Rohit","rohit@abc.com")
Now check the new record is saved into employees table
SELECT * FROM employees
Output:-
+----+------------+-----------+----------------+------------+ | id | first_name | last_name | email | address | +----+------------+-----------+----------------+------------+ | 1 | Virat | Kohli | virat@abc.com | delhi | | 2 | rohit | NULL | rohit@abc.com | NULL | +----+------------+-----------+----------------+------------+