MySQL Workbench
Tags: mysql, webdev
Published: 2021-09-19 19:32:00

<!-- wp:paragraph -->
<p>You know what desktop app made the largest improvement to my workflows when I discovered it? Not <a href="https://alliterationapplications.com/tag/visual-studio-code/" data-type="post_tag" data-id="21">Visual Studio Code</a>, as much as my writing sometimes hypes it up as my preferred text editor. There were already good text editors.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>No, the desktop tool that made the biggest improvement to my workflows was <a href="https://www.mysql.com/products/workbench/" data-type="URL" data-id="https://www.mysql.com/products/workbench/">MySQL Workbench</a>. If you work with MySQL databases at all, this will make your life so much easier than navigating those databases in a command line.</p>
<!-- /wp:paragraph -->

<!-- wp:more -->
<!--more-->
<!-- /wp:more -->

<!-- wp:heading -->
<h2>Advantages</h2>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>It is much easier and more user-friendly to browse a database. You can see all the tables in a database along the side panel and clicking on one inserts it into a query, avoiding typos copying it. When you run a SELECT command and get lots of results in a terminal, it often doesn't stay lined up very well. It's virtually impossible to read large data sets not lined up. But in Workbench, everything stays perfectly in its columns.</p>
<!-- /wp:paragraph -->

<!-- wp:image {"id":1543,"sizeSlug":"large","linkDestination":"none"} -->
<figure class="wp-block-image size-large"><img src="https://alliterationapplications.com/wp-content/uploads/2021/09/Result-Grid-1024x459.png" alt="" class="wp-image-1543"/><figcaption>Demo of the result grid, using tests on my dev site</figcaption></figure>
<!-- /wp:image -->

<!-- wp:paragraph -->
<p>Along the same lines, it is a lot easier to apply sorting by a column, by clicking on the headers in the results. This can be faster than writing out the query.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>If you want to edit a particular record from the results you're viewing, all you need to do is hit the Form Editor option beside the results. You only need to worry about writing UPDATE queries when making bulk edits.</p>
<!-- /wp:paragraph -->

<!-- wp:image {"align":"center","id":1541,"sizeSlug":"large","linkDestination":"none"} -->
<div class="wp-block-image"><figure class="aligncenter size-large"><img src="https://alliterationapplications.com/wp-content/uploads/2021/09/Form-Editor-1024x439.png" alt="" class="wp-image-1541"/><figcaption>Demo of the Form Editor</figcaption></figure></div>
<!-- /wp:image -->

<!-- wp:paragraph -->
<p>You still need to know enough MySQL to write many types of queries, but an added bonus is that it provides syntax checking. If you know a bit but aren't an expert in writing MySQL queries, this can be a big help.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>You can have multiple sites/databases saved to quickly switch between. You can also have multiple query tabs to jump back and forth between, which can be quite helpful when investigating several tables at once.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Finally, MySQL Workbench includes a variety of features such as importing from csv and exporting to csv. That pair of features can be great if you need to migrate to another system with some data cleanup in between.</p>
<!-- /wp:paragraph -->

<!-- wp:heading -->
<h2>Download</h2>
<!-- /wp:heading -->

<!-- wp:paragraph -->
<p>You can <a href="https://www.mysql.com/products/workbench/" data-type="URL" data-id="https://www.mysql.com/products/workbench/">download MySQL Workbench for free</a>. It will prompt you to create an account, but there is also a link to download without an account if you'd prefer.</p>
<!-- /wp:paragraph -->