Insert data into table

Synatx

INSERT INTO TABLE_NAME (column1, column2, column3,...columnN)

VALUES (value1, value2, value3,...valueN);

                 (OR)

INSERT INTO TABLE_NAME VALUES (value1, value2, value3,...valueN);

id	firstName	lastName	salary	mailId
1	Krishna	Ananda	100000	krishna@krishna.com
2	Arjun	Dhanunjay	50000	arjun@arjun.com
3	Ptr	Ptr	25000	ptr@ptr.com

INSERT INTO employee values(1, "Krishna", "Ananda", 100000.00, "krishna@krishna.com");
INSERT INTO employee values(2, "Arjun", "Dhanunjay", 50000.00, "arjun@arjun.com");
INSERT INTO employee values(3, "Ptr", "Ptr", 25000.00, "ptr@ptr.com");

Above statements add the records to employee table.

Prevoius                                                 Next                                                 Home