Weekly Reading for week of 10-13-2018

Enjoy the weekend with these great open-source SQL blog posts from around the web… At times, a few may be a bit dated, but worth the read, while others are relatively current… Share them along…


DEFAULT Constraint in MySQL with examples.

Column DEFAULT values can play an important role in maintaining data integrity. In the event no value is provided for DML operations, the DEFAULT constraint can ‘pick up the slack’. While MySQL does support the DEFAULT column constraint, there are some nuances to be aware of. Want to explore and learn them with me? Let’s go!

[More MySQL blogging this way >>>]

Determine secure-file-priv variable path in MySQL with these 2 commands.

Potentially, when running LOAD DATA INFILE or SELECT INTO OUTFILE commands in MySQL, you may be faced with a --secure-file-priv error… So what does this error mean in reference to reading and writing files? What location can you write to or load data from on your server? This blog post will show 2 easy commands to determine the location according to your install…

[Great MySQL blogging this way >>>]