outfile.md

PHP Database

Go back

Outfile

use MichaelRushton\Database\SQL\Components\Outfile;

$stmt->intoOutfile('/path/to/file', function (Outfile $outfile)
{

});
// SELECT ... INTO OUTFILE '/path/to/file'

characterSet

$outfile->characterSet('utf8mb4');
// SELECT ... INTO OUTFILE '/path/to/file' CHARACTER SET utf8mb4

fieldsTerminatedBy

$outfile->fieldsTerminatedBy(',');
// SELECT ... INTO OUTFILE '/path/to/file' FIELDS TERMINATED BY ','

fieldsEnclosedBy

$outfile->fieldsEnclosedBy('"');
// SELECT ... INTO OUTFILE '/path/to/file' FIELDS ENCLOSED BY '"'

fieldsOptionallyEnclosedBy

$outfile->fieldsOptionallyEnclosedBy('"');
// SELECT ... INTO OUTFILE '/path/to/file' FIELDS OPTIONALLY ENCLOSED BY '"'

fieldsEscapedBy

$outfile->fieldsEscapedBy('\\');
// SELECT ... INTO OUTFILE '/path/to/file' FIELDS ESCAPED BY '\'

linesStartingBy

$outfile->linesStartingBy('');
// SELECT ... INTO OUTFILE '/path/to/file' LINES STARTING BY ''

linesTerminatedBy

$outfile->linesTerminatedBy('\n');
// SELECT ... INTO OUTFILE '/path/to/file' LINES TERMINATED BY '\n'