Here is the query:

insert into student(firstname,lastname,email,dob,phone) values('Roseindia','Technologies','rose@roseindia.net','2011-04-14',1111);

For the above code,we have created a table named 'student':

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,                     
           `phone` int(20) default NULL,                          
           `dob` date default NULL,                               
           `marks` int(255) default NULL,                         
            PRIMARY KEY  (`id`)                           
         );