how to INSERT DATA INTO A TABLE in mysql

You need permission in order to insert data into a table. There are many ways you can insert data into a table. You can insert data from other tables or you can insert row by rows, or multiple rows.

CREATE PROFILE TABLE AND INSERT SOME SAMPLE DATA IN ORDER TO USE IN THIS TUTORIAL

>>DROP TABLE IF EXISTS `profile`;

CREATE TABLE profile (

id int(11) NOT NULL auto_increment,

first_name varchar(200) default NULL,

last_name varchar(200) default NULL,

email varchar(200) default NULL,

PRIMARY KEY  (id)

) ;

>>INSERT INTO profile VALUES

(1,'Mirza','Galib','gli@gmail.com'),

(2,'Anamul','Haque','ana@gmail.com'),

(3,'Mamun','goodgood','mun@gmail.com'),

(4,'Sayem','Tutul','abu@gmail.com'),

(5,'Sohel','Alom','sohel@gmail.com'),

(6,'Abu','Hanif','hanif@gmail.com');

Display