0

i have to generate a CSV file of full database/table when any new row comes in table.

so is there any script using i can generate CSV file.

i use MySQL to store data in database from HTML Form.

plz help

Lalit Kumar
  • 1,838
  • 2
  • 24
  • 43

2 Answers2

2

Finally, I found a beautiful tutorial to export data from Database to CSV File.

Also one answer on Stackoverflow.

sqlcmd -S . -d DatabaseName -E -s, -W -Q "SELECT * FROM TableName" > C:\Test.csv
Community
  • 1
  • 1
Lalit Kumar
  • 1,838
  • 2
  • 24
  • 43
0

Alternatively, you can use Skyvia, a cloud solution with native support for CSV file export from MySQL database. Just type in the query or use the Query Designer for a no-code solution then export the results to CSV. See an example below:

mysql-query-to-csv

After the results appear, simply click the CSV button and a CSV download will appear in your browser.

sahil wadhwa
  • 1