Skip to main content
  • MySQL Workbench and Windows 10

    Publish Date: October 9th, 2015 | Posted in Debugging, Windows 10 | Last Updated

    The type initializer for ‘HtmlRenderer.Utils.FontsUtils’ threw an exception Ok. Not cool at all. But here’s the fix: VIOLA! This fix just works! [1 Jul 13:03] Luka Pribanić I can confirm that a fixed “HtmlRenderer.dll” posted by Frank Quinteroon 21 Jun 2015 used with MySQL Workbench v. (build 828) is the first GA version after […]

  • Efficiently Remove All But Top n Rows from a MySQL Table

    Publish Date: November 14th, 2014 | Posted in Code Better, Debugging | Last Updated

    MySQL: Use TRUNCATE to Reuse Deleted Indexes This technique is useful if, for example, “x” errant rows were recently added to a table and you not only want to programmatically delete those rows, but also reuse their auto increment values: Specific Example and Solution Explanation Problem Statement We have a 40 row table and recently […]

  • Class 5: SQL Basics & MySQL Configuration

    Publish Date: February 18th, 2014 | Posted in LAMP Stack 101 | Last Updated

    Overview This guide serves as the teaching notes and class curriculum for Class 5 of our LAMP Stack 101 Learning Track. Herein, we explore configuration and common housekeeping tasks performed from the MySQL command-line. As is the case with all of our study guides, this classroom tutorial is a living document. It will be reviewed, […]