If you’ve upgraded to the TeamSQL Pro Plan, you have access to the Snippets feature, which is designed to help you do more with less typing. In this post, we’ll talk about what snippets are and what snippets available to those using TeamSQL with their MySQL, PostgreSQL, and SQL Servers.
What are Snippets?
Snippets are templates that help you to build longer queries. Because TeamSQL knows which database you’re working in, you’ll get the right snippet at the right time (if you work in multiple types of databases, you’ll know how easy it is to get similar-but-different syntaxes mixed up). Now, you’re less likely to run a query that works for MySQL against SQL Server (or vice versa).
If you can’t remember the specific syntax, Intellisense can help you out. You can “scroll” through the list of snippets using your arrow keys, and when you’ve found the one you’re interested in, press tab to populate your query window with the snippet. Additionally, if you don’t recall what a specific snippet should do, the drop-down list of snippets includes a brief definition.
You can find a detailed list of the snippets available on the docs site:
If you’re using AWS Redshift, we’ve written a separate post for those snippets. In addition to the CRUD commands available to users of MySQL, PostgreSQL, and SQL Servers, Redshift users have access to addition Redshift-specific commands.