ufotab.sql

来自「计算卫星天线角度」· SQL 代码 · 共 55 行

create table ufotab(sname varchar(50) not null,
                     卫星经度 float(10) not null,
                     primary key(sname));

insert into ufotab values('雅玛尔202'   ,     '49.0'); 
insert into ufotab values('新天703'     ,    '57.0'); 
insert into ufotab values('国际704'     ,     '66.0'); 
insert into ufotab values('泛美7/10号'  ,    '68.5'); 
insert into ufotab values('Eutelsat W5' ,     '70.5'); 
insert into ufotab values('泛美4号'     ,     '72.0'); 
insert into ufotab values('印度Insat-3C' ,    '74.0'); 
insert into ufotab values('ABS-1'        ,    '75.0'); 
insert into ufotab values('亚太2R'       ,    '76.5'); 
insert into ufotab values('泰星2/5号'    ,    '78.5'); 
insert into ufotab values('(俄)快车AM2'  ,    '80.0'); 
insert into ufotab values('印度Insat-2E/3B' , '83.0'); 
insert into ufotab values('印度Insat-4A'  ,   '83.0'); 
insert into ufotab values('国际709'     ,     '85.2'); 
insert into ufotab values('中卫一号'    ,     '87.5'); 
insert into ufotab values('中新一号'    ,     '88.0'); 
insert into ufotab values('雅玛尔201'   ,     '90.0'); 
insert into ufotab values('马星一号'    ,     '91.5'); 
insert into ufotab values('印度Insat-3A'  ,   '93.5'); 
insert into ufotab values('新天6号'     ,     '95.0'); 
insert into ufotab values('亚洲二号'    ,    '100.5'); 
insert into ufotab values('(俄)快车A2'   ,   '103.0'); 
insert into ufotab values('亚洲3S'     ,     '105.5'); 
insert into ufotab values('印尼电信1号 '  ,  '108.0'); 
insert into ufotab values('新天11号'      ,  '108.2'); 
insert into ufotab values('百合花1A'    ,    '110.0'); 
insert into ufotab values('百合花2A/2C'  ,   '110.0'); 
insert into ufotab values('N-SAT 110'    ,   '110.0'); 
insert into ufotab values('鑫诺一号'     ,   '110.5'); 
insert into ufotab values('帕拉帕-C2'    ,   '113.0'); 
insert into ufotab values('韩星5号'      ,   '113.0'); 
insert into ufotab values('中星6B '      ,   '115.5'); 
insert into ufotab values('韩星3号'      ,   '116.0'); 
insert into ufotab values('印尼电信2号'  ,   '118.0'); 
insert into ufotab values('泰星1A '      ,   '120.0'); 
insert into ufotab values('亚洲四号'     ,   '122.0'); 
insert into ufotab values('日本通信4A'   ,   '124.0'); 
insert into ufotab values('鑫诺三号'     ,   '125.0'); 
insert into ufotab values('日本通信3A'   ,   '128.0'); 
insert into ufotab values('亚太VI'       ,   '134.0'); 
insert into ufotab values('亚太V号'      ,   '138.0'); 
insert into ufotab values('(俄)快车AM3' ,    '140.0'); 
insert into ufotab values('日本超鸟C'    ,   '144.0'); 
insert into ufotab values('(俄)Gorizont45' , '145.0'); 
insert into ufotab values('马布海一号'   ,   '146.0'); 
insert into ufotab values('马星二号'     ,   '148.0'); 
insert into ufotab values('日本通信2A'   ,   '154.0'); 
insert into ufotab values('泛美8号'      ,   '166.0'); 
insert into ufotab values('泛美2号'      ,   '169.0'); 
insert into ufotab values('AMC23'        ,   '172.0');