Categories

Updated: 12/29/2006

MySQL to CSV Download

Extracts data from MySQL. Uses a MySQL table name or SQL statement to determine what data to extract. Formats the data into comma-delimited format, csv. Automatically translates invalid characters, such as &" to valid characters. Quotes columns where a field contains a comma. Starts the csv file download. Optionally you can define: A value to use if the MySQL column contains a null value. The file name for the download file. A password that is required to download the file. How quotes are used for columns with commas. Whether or not the MySQL column names are included as the first line of the csv file. A delimiter other than a comma. The following are required: Have MySQL and php installed. A text editor, like Notepad. Have a valid MySQL User Id and password with appropriate permission for the database being accessed. Ability to transfer MySQL to CSV Download to your web server with ftp or similar.
©2019 A--9.com