日期:2014-05-17 浏览次数:20498 次
drop table PRODUCT_CAR;
create table PRODUCT_CAR(Code varchar(100),Description varchar(100),parent_id varchar(20))
insert into PRODUCT_CAR select * from (
select '0' as code, 'car' as Description,'' as parent_id union all
select '1' as code, 'BMW' as Description,'0' as parent_id union all
select '2' as code, 'BENZ' as Description,'0' as parent_id union all
select '3' as code, 'VW' as Description,'0' as parent_id union all
select '4' as code, 'Hummer' as Description,'0' as parent_id union all
select 'B5' as code, 'BMW 5 series' as Description,'1' as parent_id union all
select 'B6' as code, 'BMW 6 series' as Description,'1' as parent_id union all
select 'B7' as code, 'BMW 7 series' as Description,'1' as parent_id union all
select 'Z1' as code, 'BZ Home Series' as Description,'3' as parent_id union all
select 'Z2' as code, 'BZ Sercial series' as Description,'3' as parent_id union all
select '1A' as code, 'BZ A series' as Description,'Z1' as parent_id union all
select '1B' as code, 'BZ B series' as Description,'Z1' as parent_id union all
select 'ZS' as code, 'BZ S series' as Description,'Z2' as parent_id union all
select 'V1' as code, 'VW Home Series' as Description,'ZS' as parent_id union all
select 'V2' as code, 'vw Sercial series' as Description,'3' as parent_id union all
select 'V3' as code, 'AUDIO Sercial series' as Description,'3' as parent_id union all
select 'V001' as code, 'VW SUVS series' as Description,'V1' as parent_id union all
select 'VA01' a