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.
Comments
Post a Comment