Subversion Repositories cheapmusic

Rev

Rev 44 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 44 Rev 58
Line 37... Line 37...
37 
OPTIONALLY ENCLOSED BY '"'
 37 
OPTIONALLY ENCLOSED BY '"'
38 
ESCAPED BY ''
 38 
ESCAPED BY ''
39 
LINES TERMINATED BY '\n'
 39 
LINES TERMINATED BY '\n'
40 
(id, @track_comp_data)
 40 
(id, @track_comp_data)
41 
SET track=COMPRESS(@track_comp_data);
 41 
SET track=COMPRESS(@track_comp_data);
- 
 
 42 
 
- 
 
 43 
#
- 
 
 44 
# Barcodes
- 
 
 45 
#
- 
 
 46 
LOAD DATA LOCAL INFILE 'out/barcodes.load' REPLACE
- 
 
 47 
INTO TABLE barcodes
- 
 
 48 
FIELDS TERMINATED BY ','
- 
 
 49 
OPTIONALLY ENCLOSED BY '"'
- 
 
 50 
ESCAPED BY ''
- 
 
 51 
LINES TERMINATED BY '\n';