Documentation 15 results

Sharing And Managing Shared Results

TeamSQL allows you to share the set of data returned after you execute a query via hyperlink. This means that you can share this data with somebody regardless of whether the person uses TeamSQL or not. The user to whom you’re sharing simply navigates to the URL you provide to see the data.   Share Results Before you can share your results, you’ll need to execute a query to return a set of data.   Once you’ve returned a set of results, you can right-click and ...

How To Share Folders

In this article, we will cover how you can share the folders you’ve created in TeamSQL. You can share them with individuals or with groups of individuals. To get started, navigate to the Saved Queries area of TeamSQL. You’ll see a list of all the queries you saved, as well as the folders you’ve created to store them.     Select the folder you want to share. You’ll see the options associated with that folder appear in the toolbar at the top. Click Share to ...

TeamSQL SDK and Extensions

TeamSQL supports extensions. You can easily build your extensions in TypeScript using TeamSQL Extensions SDK and teamsql-cli. TeamSQL Extension Store is also available in this version. You can publish your extensions in TeamSQL Extension Store and let other users install and use your extension.     Documentations, Samples and Tutorials SDK Documenation: https://developer.teamsql.io Export to Google (Sample Code): https://github.com/TeamSQL/...

Getting Started with Charts in TeamSQL

Prerequisites Before you begin, please be sure to: Download and install TeamSQL Sign up for a TeamSQL account and use your credentials to log into your local instance of TeamSQL Connect to a database that contains the data you want to chart.   Creating a Chart The first thing you’ll need to do is open up a new query window.   Write your query and execute it so that you return the data you want to chart.     Notice that there’s ...

PostgreSQL Snippet List

Snippets are available with TeamSQL Pro Plan. First item is the label of snippet so you can start writing one of the labels in TeamSQL Query Editor and use them.       SELECT * FROM... Simple SELECT command SELECT * FROM with WHERE clause... Simple SELECT command with WHERE clause SELECT with INNER JOIN... SELECT Command with INNER JOIN INSERT INTO... Insert into a table on "public" INSERT INTO with SELECT... Insert into a table on "public" using ...

Microsoft SQL Server Snippets

Snippets are available with TeamSQL Pro Plan. First item is the label of snippet so you can start writing one of the labels in TeamSQL Query Editor and use them.       SELECT * FROM... Simple SELECT command SELECT * FROM with WHERE clause... Simple SELECT command with WHERE clause SELECT with INNER JOIN... SELECT Command with INNER JOIN INSERT INTO... Insert into a table on "dbo" INSERT INTO with SELECT... Insert into a table on "dbo" using SELECT...

MySQL Snippet List

    Snippets are available with TeamSQL Pro Plan. SELECT * FROM... Simple SELECT command SELECT * FROM with WHERE clause... Simple SELECT command with WHERE clause SELECT with INNER JOIN... SELECT Command with INNER JOIN INSERT INTO... Insert into a table on "current database" INSERT INTO with SELECT... Insert into a table on "current database" using SELECT DELETE FROM... Delete rows from a table on "current database" UPDATE with WHERE clause... Up...

Redshift Snippet List

Snippets are available with TeamSQL Pro Plan. First item is the label of snippet so you can start writing one of the labels in TeamSQL Query Editor and use them.       SELECT * FROM... Simple SELECT command SELECT * FROM with WHERE clause... Simple SELECT command with WHERE clause SELECT with INNER JOIN... SELECT Command with INNER JOIN INSERT INTO... Insert into a table on "public" INSERT INTO with SELECT... Insert into a table on "public" using ...

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

Sharing to Slack

You can 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.       Read full article and tutorial on TeamSQL Blog.

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

Basic Math Operations

TeamSQL comes with built-in, basic math 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. To get a quick overview of our data, we begin by selecting the data cells we want included in our calculations.   As soon as we do this, we can see the results of our math operations at the bottom right of the TeamSQL window...

TeamSQL Application Preferences

TeamSQL ships with a standard set of settings, called preferences, that you can change as you'd like. To access and set your application preferences, go to File > Preferences.   There are two tabs, each of which contains a different set of settings: General Keyboard   General Settings The general tab includes the settings and preferences that affect how your editor window behaves.   In the General tab, you can set the following parameters:...

Adding a new database connection

In the Explorer pane, click on the plus icon next to CONNECTIONS.   This launches the Add Connection window where you can create new connections from TeamSQL to your server(s).   To create a connection to a MySQL database set the Database Type to MySQL.   Note how the window now displays Create a new MySQL connection at the top. To connect to your MySQL database server, you’ll need to provide the following parameters to TeamSQL:   ...