|
In a previous post I discussed the stumbling blocks and security concerns that the mysql documentation doesn’t tell you about having a mysql user create csv files on the filesystem. I ran into yet another issue. In order to do what I want with these csv’s, they have to have column headers. I thought . . . → Read More: MySQL CSV’s with column headings — Part 1  3 comments - (Comments are closed)  Geek Stuff, Hacking and Security, SQL  cache, CAST, column headers, column heading, CSV, Database Abstraction, dependency injection, describe table, descriptors, FILE permission, length, metadata, MySQL, pear, reflection, system user, truncate, truncation, UNION 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 I was getting the nitpicky error 150 when trying to create an InnoDB table with foreign keys. I had very carefully checked several times that all the key types and names matched exactly including UNSIGNED (which is what gets most people), and that I had an index on every foreign key as required by my . . . → Read More: MySQL InnoDB Create Table composite key problem and solution 9 comments - (Comments are closed) Geek Stuff, SQL Can't create table, composite key, composite primary key, create table, Error 150, example, foreign key, index, InnoDB, key, key order, MySQL, reference table, references How to create, see and update table comments so your database scheme is somewhat self documenting . . . → Read More: How to create and maintain table comments in MySQL 14 comments - (Comments are closed) Geek Stuff, SQL access, alter table, comment, create, creating a table, database, effort, multiple, MySQL, SHOW, SQL, table, table comments, update |
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