56,940
社区成员




Create table BaseInfo
(
id int(4) PRIMARY auto_increment,
name varchar(10) not null ,
area DECIMAL(10,2),
feestartdate date,
feeenddate date
);
Create table Price
(
pid int(4) PRIMARY auto_increment,
name VARCHAR(10) not null,
amount DECIMAL(10,2),
pricestartdate date,
priceenddate date
);
insert into BaseInfo(name,area,feestartdate,feeenddate) values('A1',25.2,'2015-06-05','2016-07-02'),('A2',31.2,'2015-06-01','2015-07-31'),('A3',20,'2015-06-30','2015-07-25');
insert into Price(name,amount,pricestartdate,priceenddate) values('A1',2.5,'2015-01-01','2015-06-15'),('A1',3.1,'2015-06-16','2015-12-31'),('A2',3.1,'2015-01-01','2015-12-31'),('A3',3.1,'2015-01-01','2015-6-30'),('A3',2.9,'2015-07-01','2015-12-31');