Use the following query to create a table will all the fields:

CREATE TABLE student (
id bigint(20) NOT NULL auto_increment,
firstname varchar(100) default NULL,
lastname varchar(100) default NULL,
email varchar(100) default NULL,
pass varchar(100) default NULL,
confirm_pass varchar(100) default NULL,
dob date default NULL,
age int(100) default NULL,
gender varchar(10) default NULL,
address varchar(100) default NULL,
country varchar(100) default NULL,
state varchar(100) default NULL,
city varchar(100) default NULL,
telephone int(20) default NULL,
mobile int(20) default NULL,
PRIMARY KEY (id)
);

Now to insert the data, here is the insert query:

insert into student (firstname,lastname,email,pass ,confirm_pass ,dob ,age ,gender ,address ,country ,state ,city ,telephone ,mobile) values('rose','india','rose@roseindia.net','roseindia','roseindia','2011-04-14',20,'M','rohini','India','Delhi','Delhi',1111,2222);