How to Insert Records into MySQL Table
Notes:
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,...);
Ex:
insert into tbl_student(id,name) values(1,'ramesh');
Interview Questions:
