Don’t you hate it when you know you solved a problem three years ago but you can’t remember what the solution was? I ran into that recently. I was trying to make mysql generate a csv directly from query results. I remembered that you can do it, and I had an example of the correct . . . → Read More: How to make MySQL spit out CSV’s
 22 comments - (Comments are closed)  Geek Stuff, SQL  CSV, DoS, escapes, FILE privilege, filesystem, INTO OUTFILE, MySQL, mysql system user, mysql user, OUTFILE, permissions, security, vulnerability Ouch! I just solved a puzzling error in Zend Framework. It was telling me that I had an illegal file name. While the trace never did point to the exact line in my code that triggered it, it clearly had something to do with a PDO_SQL database. I checked the database file and . . . → Read More: OW! Zend Framework bit me OR Careful with that config One comment - (Comments are closed) Zend Framework apostrophes, application.ini, config file, database file, illegal file name, PDO_SQL, permissions, single quotes, Zend Framework |
Column Comments in MySQL
A while back I was lamenting that table comments in MySQL get overlooked, and did a post on it, both how to create them, how to update them, and how to view them. The fact that my table comment post remains quite popular indicates that mySQL hasn’t SEO’d their pages on it thoroughly enough, . . . → Read More: Column Comments in MySQL