MySQL Insert Data

 How to Insert Data in Table?

Syntax:

Code:

Insert into student_data (_RollNo, Name, Class, Gender, Fall)

values (1, "Aqib", "MSC", "Male", 2022);

Click Execute button.

Multiple Insert Data in Table:

Syntax:

Code:

insert into student_data (_Roll_No, Std_Name, Std_class, Std_Gender, Std_Fall)

values

(1, "Saqib", "MS", "Male", 2022),

(2, "Asif", "M Phil", "Male", 2022),

(3, "Ali", "Bsc", "Male", 2022);

Click Execute button.