SQLize Online / PHPize Online  /  SQLtest Online

create database if not exists `visa`; USE `visa`; CREATE TABLE `applicationentry` ( `ApplnID` varchar(50) NOT NULL, `EmpID` varchar(50) default NULL, `ExeID` varchar(50) default NULL, `NoOfTimeToOnsite` varchar(50) default NULL, `Country` varchar(50) default NULL, `Type` varchar(50) default NULL, `Enquiry` varchar(50) default NULL, `Interview` varchar(50) default NULL, `Results` varchar(50) default NULL, `OnsiteDeparture` varchar(50) default NULL, `Reports` varchar(50) default NULL, `OnsiteArrival` varchar(50) default NULL, `Date` datetime default NULL, PRIMARY KEY (`ApplnID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; insert into `applicationentry`(`ApplnID`,`EmpID`,`ExeID`,`NoOfTimeToOnsite`,`Country`,`Type`,`Enquiry`,`Interview`,`Results`,`OnsiteDeparture`,`Reports`,`OnsiteArrival`,`Date`) values ('Apln331','1111','HrEx4331','0','US','L1','yes','yes','yes','yes','yes','yes','2009-02-14 00:00:00'); CREATE TABLE `empdetails` ( `EmpID` varchar(50) NOT NULL, `EmpName` varchar(50) default NULL, `Password` varchar(50) default NULL, `Designation` varchar(50) default NULL, `PassportNo` varchar(50) default NULL, PRIMARY KEY (`EmpID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; insert into `empdetails`(`EmpID`,`EmpName`,`Password`,`Designation`,`PassportNo`) values ('1111','Raj','raj','SE','dg345345'); CREATE TABLE `enquiry` ( `EnqID` varchar(50) NOT NULL, `ApplnID` varchar(50) default NULL, `Enteredby` varchar(50) default NULL, `Query` varchar(50) default NULL, `Ans` varchar(50) default NULL, `Date` datetime default NULL, PRIMARY KEY (`EnqID`) ) ENGINE=InnoDB DEFAULT CHARSET