Skillpundit

SQL

The INSERT INTO statement is used to insert new records in a table.

Syntax

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

Id	Student_Name	Gender	Home_Town
1	Rahul	Male	Lucknow
2	Raj	Male	Varanasi
3	Ramu	Male	Lucknow

Query: INSERT INTO `student` (`id`, `Student_Name`, `Gender`, `Home_Town`) VALUES (4,, 'Rekha', 'Female’ , ’ Delhi’);

Id	Student_Name	Gender	Home_Town
1	Rahul	Male	Lucknow
2	Raj	Male	Varanasi
3	Ramu	Male	Lucknow
4	Rekha	Female	Delhi

The UPDATE statement is used to modify the existing records in a table.

Syntax

UPDATE table_name SET column1 = value1, column2 = value2, ...
WHERE condition;

Id	Student_Name	Gender	Home_Town
1	Rahul	Male	Lucknow
2	Raj	Male	Varanasi
3	Ramu	Male	Lucknow
4	Rekha	Female	Delhi

Query: UPDATE STUDENT SET Student_Name = 'Raju', Home_Town= 'Jammu'WHERE id = 1;

Id	Student_Name	Gender	Home_Town
1	Raju	Male	Jammu
2	Raj	Male	Varanasi
3	Ramu	Male	Lucknow
4	Rekha	Female	Delhi