Project

General

Profile

1
#!/bin/sh
2
# Publishes analytical DB to nimoy
3
# Usage: self analytical_aggregate.csv
4

    
5
mysql --password --database=bien3_adb <<EOF
6
LOAD DATA LOCAL INFILE '$1'
7
INTO TABLE analytical_aggregate
8
FIELDS TERMINATED BY ','
9
OPTIONALLY ENCLOSED BY '"'
10
ESCAPED BY '"'
11
IGNORE 1 LINES
12
;
13
EOF
(48-48/68)