Download the PHP package mrmarkfrench/mysql-converter without Composer
On this page you can find all versions of the php package mrmarkfrench/mysql-converter. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download mrmarkfrench/mysql-converter
More information about mrmarkfrench/mysql-converter
Files in mrmarkfrench/mysql-converter
Package mysql-converter
Short Description A quick-and-dirty tool for converting raw MySQL query output to CSV.
License MIT
Homepage https://github.com/mrmarkfrench/mysql-converter
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package mysql-converter
mysql-converter
A quick-and-dirty tool for converting raw MySQL query output to CSV.
What it's for
This tool is intended as a quick way to convert raw MySQL query output to CSV without requiring a lot of manual manipulation of the data in a text editor. It does a reasonable job of handling cases where the data contains line breaks, commas, copies of the field delimiter character, different line ending character(s) than the file as a whole, etc. In general, if your data is more-or-less clean, the tool will get the job done.
That said, the tool only goes so far. Particularly if the data in your query result is user-supplied, there are no guarantees in life. The tool will do its best to sort things out, but there will be some cases where it simply isn't able to sort out where one field ends and the next begins, and in those cases it will throw an exception and you'll need to go clean up your data before you can continue.
What this is NOT
This tool is not the best choice if you have filesystem access to your MySQL server. In that case, MySQL already provides tools to output CSV, and will do a much better job of dealing with particularly gnarly data than this tool. If you have access to the filesystem on your MySQL server, check the SELECT ... INTO OUTFILE syntax in the MySQL documentation.
A word of caution
In most cases, you will be converting data to CSV so that you can import it into a spreadsheet somewhere. There are some values that a malicious user might have placed into your database which while both MySQL and this tool will handle them without incident, might cause Excel to execute possibly dangerous and arbitrary code if the data is imported with macros and VB scripting turned on.
You should never import user data into Excel with these features enabled. This tool makes no attempt to detect or remove such content. Your users are almost certainly terrible people and shouldn't be trusted. Proceed at your own risk.
Quickstart
Contributions
Please feel free to fork this repository and add new features as necessary. The existing functions should give you a solid framework to build on, and your pull requests are welcome.
- Fork it
- Create your feature branch (
git checkout -b my-new-feature) - Commit your changes (
git commit -am 'Add some feature') - Push to the branch (
git push origin my-new-feature) - Create new Pull Request
