Features 19 results

Custom Snippets

What are snippets? Snippets are templates that you can use to help you 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 ...

Exporting Data to CSV or JSON in TeamSQL

You can easily export the data contained in your database tables in one of the following formats: CSV JSON Tab Separated   Read full article and tutorial on TeamSQL Blog.

Filtering Data Grid

After executing a query that returns a large results set, TeamSQL allows you to filter the returned data without running another query. This allows you to analyze your results set without any additional queries or strain on your server. Let’s look at an example. This is what our initial results set looks like after executing a query.   Notice the search bar and funnel icon located above each column. These allow you to filter on one or more columns. If you have search ...

Keep your data safe with QuerySense

I will start this article with a real-life story, occurred to me. As a database consultant, I do a lot of different works. I write technical articles (apparently), but I also do some other database tasks like SQL development and database administration. So I have a lot of SQL clients and tools installed on my notebook. One sunny day I begin to work in the morning, while I enjoyed a coffee I opened my SQL client, and I run a simple script to create and populate a table for an article I was ...

Sharing Your TeamSQL Folders

In our opinion, one of the most significant benefits to using TeamSQL is the ability to share your work with your teammates, either individually or with groups of individuals, with ease. Rather than going through the traditional practice of exporting your query, saving it somewhere, and then forwarding the access directions to your colleagues, you can let TeamSQL do the heavy lifting. Just provide information about who you’d like to share with and the recipients’ email addresses, and ...

Custom Snippets

TeamSQL has supported snippets for some time, but we’re introducing custom snippets to help you work more effectively.   What are the snippets? From our snippets post: Snippets are templates that can 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 ...

Math Operations on Selected Cells

TeamSQL now comes with built-in, basic operations, so you have easy access to summary statistics for your data, such as totals, counts, averages, and maximum and minimum values. You can have these operations run on any set of cells you’ve highlighted. Here’s how you can get this information. Let’s say that we’ve executed a query and have the following sales information:       To get a quick overview of our data, we begin by selecting the data cells we want to ...

Filtering Your Data Grid

After executing a query that returns a massive results set, TeamSQL allows you to filter the returned data without running another query. This process will enable you to analyze your results set without any additional queries or strain on your server. Let’s look at an example. The screenshot below is what our initial results set looks like after executing a query. Notice the search bar and funnel icon located above each column. These allow you to filter on one or more columns. If you ...

Sharing Your Query Results to Slack

TeamSQL is always looking for ways to make collaborating with your colleagues on SQL queries easier, and today, you have one more way to share the results of your SQL query: via Slack! You can now run a query and send the results to the Slack channel, group, or user of your choice. Your colleagues can then access the data by clicking on the hyperlink provided by TeamSQL. To keep your data safe, you can choose to encrypt and password-protect your results set. How to Share Your Query Results ...

Table Structure Previews

One of TeamSQL’s newest features is the ability to preview the structure of a particular table. You’ll be able to view the table’s column definitions, as well as information about any indexes that might be on the table.     You can access this information in one of two ways: the first is to open up a pop-up window containing the table structure information, and the second is view it in the Connections Pane. Begin by hovering over the name of a table in the left-hand ...

TeamSQL Snippets

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 ...

Using TeamSQL Snippets with Redshift

If you’ve upgraded to the TeamSQL Pro Plan, you have access to the Snippets feature, which we think you’ll love. In this post, we’ll talk about what snippets are and the snippets available to those using TeamSQL with their Redshift databases. We’ll begin by covering three Redshift-specific snippets and end by including the usual CRUD commands at the end of the post.       What are Snippets? Snippets are templates that help you can use to build longer ...

Sharing Data Via Hyperlink

If you’ve ever wanted to share data with someone, but that person wasn’t a user of TeamSQL, you had to export the data and send it to that person. He or she would then have to import the data into the appropriate app to see your dataset. This process isn’t necessarily complicated, but wouldn’t it be nice if there was a more natural way to share data with someone? Try TeamSQL for free: https://teamsql.io/ As another feature facilitating secure collaboration, you can now share TeamSQL ...

Deleting Duplicate Data

In most cases, you don’t want duplicate rows in your database. The best practice is to set up your insert process so that data that is already in your tables aren’t added again, but what if that horse has left that barn and you already have duplicates?     In this post, we’ll show you how you remove duplicate data in your MySQL databases.   At a Glance There are just a few necessary steps when removing duplicate data from your table: Back up your ...

Using the CREATE Procedure and INSERT INTO Statement Templates

TeamSQL comes with built-in templates to guide you as you create new procedures or statements that change your databases. In this article, we’ll cover using the CREATE Procedure and INSERT INTO Statement Templates.   Procedure Template: CREATE In a new TeamSQL query tab, begin typing CREATE. Notice that, as you type, the drop-down menu of options filters. When you see CREATE PROCEDURE highlighted, you can hit the ENTER key to populate the window with a CREATE stored procedure ...

Working with Teams in TeamSQL

In this article, we will cover the features TeamSQL has that enables easy collaboration between you and your colleagues.   Creating a Team To create a new team, which you can use to group any number of users, navigate to Teams > Create New Team using the main toolbar at the top. You will be prompted to provide a name for your new team.   Click Create to proceed. On the Teams & Management window that displays, you see your newly-created team, along ...

Saving and Managing Queries in TeamSQL

You can easily save the queries you execute in TeamSQL for future reference.     You can initiate a save by clicking Save Query, using CTRL + S (in Linux or Windows), or using ⌘ + S (in macOS). You will be prompted to provide a name for your query if this is the first time you’ve saved.   TeamSQL now displays the name of your query in the query’s tab, as well as in the left-hand navigation bar.   Viewing Your Saved Queries In addition to accessing ...

Exporting Data Using TeamSQL

    You can easily export the data contained in your database tables in one of the following formats: CSV JSON Tab Separated NOTE: You can connect to AWS Redshift with TeamSQL, a multi-platform DB client that works with Redshift, PostgreSQL, MySQL & Microsoft SQL Server and runs on Mac, Linux and Windows. You can download TeamSQL Beta for free: https://teamsql.io/   How to Export Data 1. Launch TeamSQL, and connect to your database server by ...

Using Keyboard Shortcuts in TeamSQL

There are numerous shortcuts that allow you to perform actions faster. Below is a list of shortcuts you can use in TeamSQL, as well as information on where you can use them.   Apple macOS   General Keyboard Shortcuts Open search box — search for any item ⌘ ⇧ F Open search box — search for table names ⌘ ⇧ T Open search box — search for functions and stored procedure ⌘ ⇧ P Import SQL file ⌘ O   Shortcuts for Use in the Editor Exec...