Keep safe your data 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 (obviously), 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 own 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 biggest 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.
Simply provide information about who you’d like to share with and the recipients’ email addresses, and TeamSQL ...
TeamSQL has supported snippets for some time, but we’re introducing custom snippets to help you work more effectively.
What are snippets?
From our snippets post:
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 ...
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 ...
Filtering Your 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 ...
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 ...
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 ...
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 you can use to help you build longer queries. Because TeamSQL knows which database you’re working in, ...
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 covering the usual CRUD commands at the end of the post.
What are Snippets?
Snippets are templates that you can use to help you 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 difficult, but wouldn’t it be nice if there was an easier way to share data with someone?
Try TeamSQL for free: https://teamsql.io/
As another feature facilitating easy collaboration, you can now ...
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 basic steps when removing duplicate data from your table:
Back up your table!
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 enable 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:
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:
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.
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
Shortcuts for Use in the Editor