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…

Update records in a table on “current database”

CREATE PROCEDURE…

Create procedure on “current database”

DROP STORED PROCEDURE…

Drop a procedure from “current database”

CALL STORED PROCEDURE…

Call a stored procedure on “current database”

CREATE FUNCTION…

Create a function on “current database”

DROP FUNCTION…

Drop a function on “current database”

CALL FUNCTION…

Call a function on “current database”

CREATE TABLE (Simple)

Create a table on “current database”

CREATE TABLE (with Primary Key and index)

Create a table on “current database” with Primary Key and index

DROP TABLE…

Drop a table on “current database”

ALTER TABLE…

Alter a table on “current database”

SELECT INTO (Structure only)

Create a table (only structure) on “current database” like another one

SELECT INTO (Structure & Data)

Create a table (structure & data) on “current database” like another one