How to Import & Export MySQL Databases?
How do I import an SQL Dump file into MySQL database? 1. Using Import SQL Wizard Previously, you can import and *.sql file to use with your database in TablePlus by dragging the file into the query editor and execute it. It works just fine for the small sized file, but for a huge file, it gives the app a...
How to customize TablePlus experiences on Mac
TablePlus has many different settings to customize its behaviours. And it can be done easily via the GUI. 1. Customize the Toolbar First, you can change the layout of TablePlus’ toolbar, buttons, and colors to suit your style. If you are familiar with customizing the Safari browser window on Mac, this works the same. In the TablePlus app, right-click on...
A native database management tool for Windows
TL;DR: We are back again with the Windows version of TablePlus: A native build. Multiple drivers support MySQL, PostgreSQL, SQL Server… and the others are coming soon. Built-in SSH, no need PuTTY. It’s the fastest DB tool with streaming results row by row and async loading. Intuitive UX/UI with the high-resolution display. Active development and lifetime support. It’s 100% compatible...
How to show multiple query results separately
There are a couple ways to show multiple sets of query results simultaneously in TablePlus: 1. Split pane You can split the current SQL Query Editor into many different editors and they work separately. To split pane, right click on the current editor and choose Split pane horizontally, or simple use shortcut key Cmd + D. 2. Split results into...
Keyword Binding for Favorite Queries
There are some queries you want to reuse in different contexts or with different objects quite frequently. You can add it to favorite and assign a keyword for reference and call it quickly using that keyword later. To add a query to favorite: Select the query from the editor (you can also choose from history tab) Right-click and choose add...