Project

General

Profile

« Previous | Next » 

Revision 6474

Added by Aaron Marcuse-Kubitza about 12 years ago

publish_analytical_db: Added CSV dialect information

View differences:

publish_analytical_db
2 2 
# Publishes analytical DB to nimoy
3 3 
# Usage: self analytical_aggregate.csv
4 4 

  		




  5
  
  
    
mysql --password --database=bien_web --execute="LOAD DATA LOCAL INFILE '$1' \


  		




  6
  
  
    
INTO TABLE analytical_aggregate;"


  		




  
  5
  
    
mysql --password --database=bien_web <<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


  		












Also available in:  Unified diff