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...
Update records in a table on ...
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:
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 ...
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 ...