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 a table on "current database"
INSERT INTO with SELECT...
Insert into a table on "current database" using SELECT
Delete rows from a table on "current database"
UPDATE with WHERE clause...
Which database engines will you support?
In addition to MySQL, Microsoft SQL Server, PostgreSQL and AWS Redshift, we will be supporting those engines in the following weeks:
Keep your data safe with QuerySense
I will start this article with a real-life story: As a database consultant, I do a lot of different works. I write technical articles, do some other database tasks like SQL development and database administration. So, I have a lot of SQL clients, and tools installed on my computer. One sunny day I begin to work in the morning. While I am enjoying my coffee I opened my SQL client, and I run a simple script to create and populate a table for an article. Before I create a table, I try a “drop ...
Charting Your Data with TeamSQL
TeamSQL’s charts feature lets you visualize your database queries in just a few clicks. You can select from a variety of different chart types, perform complex data aggregation and sort, and customize the appearance of your charts right from TeamSQL. Charts work with any database supported by TeamSQL and can even be exported as images.
In this post, we’ll demonstrate TeamSQL Charts using this sample MySQL database, which contains employee and salary records for a fictional company. ...
Visualize your data with charts in TeamSQL
TeamSQL offers a new and redesigned feature to create your own charts based on query resulting data. The Charts feature of TeamSQL is now more powerful with advanced aggregation and visualization options. TeamSQL Charts is all free during Release Candidate period. Visualize your data by creating the charts you need, right in TeamSQL.
You can easily create bar, area, line, pie, scatter, funnel, and bullet charts, as well as heat maps, using the data you return from your database. You ...
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 ...
TeamSQL Charts: Pie Charts
We’ve been covering some of the new charting features in TeamSQL, and today, we’ll take a look at the pie chart. If you’re already familiar with how the basic charting functionality works in TeamSQL, read on, but if you aren’t, please take a look at our overview post.
In today’s example, we’ll be looking at the market share each of the major browsers held in the period from January to May of 2015. Here’s what our data looks like returned from the database.
We click ...
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 ...
The GROUP BY Clause
The GROUP BY statement is often used with aggregate functions (such as COUNT, MAX, and SUM) so that you can group a set of rows by one or more columns. Here’s a high-level overview of how you can use it, as well as information on how it works and some tips to keep in mind.
As an example, here’s a table with some pets data.
We can count the number of each species present in our table using the GROUP BY clause.
How the GROUP BY Clause Works
Adding a New MySQL Connection via SSH Tunnel
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:
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 ...
MySQL JSON Support & Using JSON Fields
We’ll start by creating our table. We can easily create tables in TeamSQL by running a Create procedure using a query window.
CREATE TABLE `sakila`.`json_examples`(
We’ll create a simple three-column table that will store ...
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 ...