Breaking News: Grepper is joining You.com. Read the official announcement!

Export Data From Database to CSV File

Add Answer

Relieved Rhinoceros answered on July 31, 2021 Popularity 9/10 Helpfulness 2/10

answer Export Data From Database to CSV File

related Export Data From Database to CSV File

related Export Database Records to CSV

related How to automatically export database to a csv file

Export Data From Database to CSV File

Comment

SET @TS = DATE_FORMAT(NOW(),'_%Y_%m_%d_%H_%i_%s');
SET @FOLDER = '/var/lib/sql-files/';
SET @PREFIX = 'employees';
SET @EXT    = '.csv';
SET @CMD = CONCAT("SELECT * FROM tableName INTO OUTFILE '",@FOLDER,@PREFIX,@TS,@EXT,
"' FIELDS ENCLOSED BY '"
' TERMINATED BY ',' 
ESCAPED BY '"'",
"LINES TERMINATED BY 'n';");
PREPARE statement FROM @CMD;
EXECUTE statement;

Popularity 9/10 Helpfulness 2/10 Language sql

Source: hevodata.com

Tags: csv database export file sql

Link to this answer
Share Copy Link

Contributed on Mar 11 2022

Relieved Rhinoceros

0 Answers Avg Quality 2/10

Closely Related Answers

Export Data From Database to CSV File

Comment

SELECT column_a,column_b,column_c+column_d INTO OUTFILE '/tmp/result.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM test_table;

Popularity 9/10 Helpfulness 3/10 Language whatever

Source: support.spatialkey.com

Tags: csv

Link to this answer
Share Copy Link

Contributed on Mar 11 2022

Relieved Rhinoceros

0 Answers Avg Quality 2/10

Export Database Records to CSV

Comment

<?php
$conn = mysqli_connect("localhost","root","test", "phppot_examples");

$query = "SELECT * FROM toy";
$result = mysqli_query($conn, $query);

$num_column = mysqli_num_fields($result);		

$csv_header = '';
for($i=0;$i<$num_column;$i++) {
    $csv_header .= '"' . mysqli_fetch_field_direct($result,$i)->name . '",';
}	
$csv_header .= "\n";

$csv_row ='';
while($row = mysqli_fetch_row($result)) {
	for($i=0;$i<$num_column;$i++) {
		$csv_row .= '"' . $row[$i] . '",';
	}
	$csv_row .= "\n";
}	

/* Download as CSV File */
header('Content-type: application/csv');
header('Content-Disposition: attachment; filename=toy_csv.csv');
echo $csv_header . $csv_row;
exit;
?>

Popularity 8/10 Helpfulness 2/10 Language php

Source: phppot.com

Tags: csv database datab

Link to this answer
Share Copy Link

Contributed on Jul 23 2022

Adventurous Ant

0 Answers Avg Quality 2/10

How to automatically export database to a csv file

Comment

sqlcmd -S . -d DatabaseName -E -s, -W -Q "SELECT * FROM TableName" > C:\Test.csv

Popularity 9/10 Helpfulness 2/10 Language sql

Source: stackoverflow.com

Tags: csv

Link to this answer
Share Copy Link

Contributed on Jul 31 2021

Sore Swan

0 Answers Avg Quality 2/10

Export Data From Database to CSV File

Contents

More Related Answers

Export Data From Database to CSV File

Closely Related Answers

Export Data From Database to CSV File

Export Database Records to CSV

How to automatically export database to a csv file

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.