Export MySQL tables to JSON

A simple and fast C program for exporting MySQL tables to JSON.

Build

• Using CMake:

  mkdir -p build
  cd build
  cmake ..
  

• Using supplied Makefile:

  # Set `BUILD_DIR` in Makefile
  # Run make from root dir
  make 
  

Run

Pipe the output of your mysql query to export-mysql-to-json. This can be done from the command line like so:

$ mysql -u <username> -p<password> -e "select * from <schema>.<table>;" | ./build/export-mysql-to-json

Here’s the resulting output for a sample table:

[ 
	{
		"id" : "1",
		"col1" : "11",
		"col2" : "12"
	},{
		"id" : "2",
		"col1" : "21",
		"col2" : "22"
	}
]

export-mysql-to-json uses column names as json keys by default, but you can change them using Mysql’s AS statement like so:

$ mysql -u <username> -p<password> -e "select <column name> as <column name alias> from <schema>.<table>;" | ./build/export-mysql-to-json