Sjors / pale-blue-dot

Making it easier to adopt a star

This URL has Read+Write access

pale-blue-dot / update-stars.sql
100644 16 lines (15 sloc) 0.405 kb
raw blame history 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

load data local infile 'adopt.txt' REPLACE into table stars
(@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);