Preparing table for HQL Examples

In this lesson we will create insurance table and populate it with the data. We will use insurance table for rest of the HQL tutorial.

To create the insurance table and insert the sample data, run the following sql query:

/*Table structure for table `insurance` */

drop table if exists `insurance`;

CREATE TABLE `insurance` (
`ID` int(11) NOT NULL default '0',
`insurance_name` varchar(50) default NULL,
`invested_amount` int(11) default NULL,
`investement_date` datetime default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;

/*Data for the table `insurance` */

insert into `insurance` values (1,'Car Insurance',1000,'2005-01-05 00:00:00');
insert into `insurance` values (2,'Life Insurance',100,'2005-10-01 00:00:00');
insert into `insurance` values (3,'Life Insurance',500,'2005-10-15 00:00:00');
insert into `insurance` values (4,'Car Insurance',2500,'2005-01-01 00:00:00');
insert into `insurance` values (5,'Dental Insurance',500,'2004-01-01 00:00:00');
insert into `insurance` values (6,'Life Insurance',900,'2003-01-01 00:00:00');
insert into `insurance` values (7,'Travel Insurance',2000,'2005-02-02 00:00:00');
insert into `insurance` values (8,'Travel Insurance',600,'2005-03-03 00:00:00');
insert into `insurance` values (9,'Medical Insurance',700,'2005-04-04 00:00:00');
insert into `insurance` values (10,'Medical Insurance',900,'2005-03-03 00:00:00');
insert into `insurance` values (11,'Home Insurance',800,'2005-02-02 00:00:00');
insert into `insurance` values (12,'Home Insurance',750,'2004-09-09 00:00:00');
insert into `insurance` values (13,'Motorcycle Insurance',900,'2004-06-06 00:00:00');

Above Sql query will create insurance table and add the

In the future lessons we will use this table to write
different HQL examples.