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

Export Database Records to CSV

Add Answer

Adventurous Ant answered on July 31, 2021 Popularity 9/10 Helpfulness 2/10

answer Export Database Records to CSV

related Export Data From Database to CSV File

related export sql result to csv

related How to automatically export database to a csv file

related Export Data From Database to CSV File

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 9/10 Helpfulness 2/10 Language php

Source: phppot.com

Tags: csv database export php records

Link to this answer
Share Copy Link

Contributed on Jul 23 2022

Adventurous Ant

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 sql result to csv

Comment

MSSQL

Invoke-Sqlcmd -Query "SELECT * from <database_name>.<schema_name>.<table_name>;" -ServerInstance "<server_instance>" | Export-Csv -Path "file_ destination_path" -NoTypeInformation

Popularity 10/10 Helpfulness 2/10 Language sql

Source: blog.devart.com

Tags: csv

Link to this answer
Share Copy Link

Contributed on Mar 09 2023

IPL CTIL

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

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

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

Contents

More Related Answers

Export Database Records to CSV

Closely Related Answers

Export Data From Database to CSV File

export sql result to csv

How to automatically export database to a csv file

Export Data From Database to CSV File

Grepper

Documentation

Social

Legal

Contact

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