Directory Structure :
1. Create database name registration1 and table tblstudent as code below :
--
-- Table structure for table `tblstudent`
--
drop database if exists registration1;
create database registration1;
use registration1;
DROP TABLE IF EXISTS `tblstudent`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tblstudent` (
`StudentID` int(5) NOT NULL default '0',
`FirstName` varchar(20) character set utf8 default NULL,
`LastName` varchar(20) character set utf8 default NULL,
`Sex` varchar(5) default NULL,
`Email` varchar(50) character set utf8 default NULL,
`Address` varchar(100) character set utf8 default NULL,
`Subject` varchar(50) default NULL,
`Sport` varchar(50) default NULL,
`Fruit` varchar(50) character set utf8 default NULL,
PRIMARY KEY (`StudentID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--------------------------