How to Insert Records into MySQL Table


How to insert a record into a table in MySQL:
- To insert a record into a table; we take help of insert into command

Note: in MySQL
- tables are also called relations
- columns are also called fields
- rows are also called records

Basic Syntax:
insert into tablename(columnname1, columnname2,...) values(value1, value2,...);

insert into tbl_student(id,name) values(1,'ramesh');

Interview Questions: