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! https://bugs.mysql.com/bug.php?id=75673 [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.6.3.4.0 (build 828) is the first GA version after […]

  • Efficiently Removing the Bottom 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 SemanticsThis may also be rephrased as “Efficiently Remove All But Top n Rows from a MySQL Table” 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 […]

  • 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, […]