Sjors / pale-blue-dot

Making it easier to adopt a star

This URL has Read+Write access

pale-blue-dot / import-stars.sql
100644 21 lines (18 sloc) 0.509 kb
raw blame history 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

load data local infile 'KIC.txt' REPLACE into table stars
IGNORE 16 LINES
(@var1)
SET id=SUBSTR(@var1, 4,10),
number=SUBSTR(@var1,1,13),
lon_d=SUBSTR(@var1,17,2),
lon_m=SUBSTR(@var1,20,2),
lon_s=SUBSTR(@var1,23,5),
lat_d=SUBSTR(@var1,31,3),
lat_m=SUBSTR(@var1,35,2),
lat_s=SUBSTR(@var1,38,4),
mag=SUBSTR(@var1,45,5),
teff=SUBSTR(@var1,54,4),
logg=SUBSTR(@var1,61,5),
mh=SUBSTR(@var1,69,5),
adopted_by=SUBSTR(@var1,78);
 
DELETE FROM stars WHERE number = " ";
DELETE FROM stars WHERE number = "-------------";