Created by: greenskeleton
I noticed a bug when trying to use the DATE_FORMAT() function with a MySQL database using mysqlconnector dialect. This function requires % characters as format specifiers, see MySQL documentation. Previously using the mysqldb dialect I had no problems.
Compare the output from the following two commands:
sql2csv --db "mysql+mysqldb://...?charset=utf8" --query "select DATE_FORMAT(NOW(), '%c'), '%' AS '%'"
sql2csv --db "mysql+mysqlconnector://...?charset=utf8" --query "select DATE_FORMAT(NOW(), '%c'), '%' AS '%'"