Revision 8270
Added by Aaron Marcuse-Kubitza almost 12 years ago
| bin/publish_analytical_db | ||
|---|---|---|
| 11 | 11 |
INTO TABLE $table |
| 12 | 12 |
FIELDS TERMINATED BY ',' |
| 13 | 13 |
OPTIONALLY ENCLOSED BY '"' |
| 14 |
ESCAPED BY '"' |
|
| 15 | 14 |
IGNORE 1 LINES |
| 16 | 15 |
; |
| 17 | 16 |
EOF |
Also available in: Unified diff
bin/publish_analytical_db: Fixed bug where need to remove `ESCAPED BY '"'` because this would causing " followed by an escape sequence char to be interpreted specially (e.g. "n -> \n). MySQL automatically takes care of quote doubling when you specify `FIELDS OPTIONALLY ENCLOSED BY`.