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'); insert into `insurance` values (14,'Motorcycle Insurance',780 ,'2005-03-03 00:00:00');

Above Sql query will create insurance table and add the following data:

ID	insurance_name	invested_amount	investement_date
1	Car Insurance	1000	2005-01-05 00:00:00
2	Life Insurance	100	2005-10-01 00:00:00
3	Life Insurance	500	2005-10-15 00:00:00
4	Car Insurance	2500	2005-01-01 00:00:00
5	Dental Insurance	500	2004-01-01 00:00:00
6	Life Insurance	900	2003-01-01 00:00:00
7	Travel Insurance	2000	2005-02-02 00:00:00
8	Travel Insurance	600	2005-03-03 00:00:00
9	Medical Insurance	700	2005-04-04 00:00:00
10	Medical Insurance	900	2005-03-03 00:00:00
11	Home Insurance	800	2005-02-02 00:00:00
12	Home Insurance	750	2004-09-09 00:00:00
13	Motorcycle Insurance	900	2004-06-06 00:00:00
14	Motorcycle Insurance	780	2005-03-03 00:00:00

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