ctrl+shift+p filters: :st2 :st3 :win :osx :linux

My​SQL Snippets

by korniychuk ALL

Many snippets for quick creation of sql commands

Labels snippets, mysql, sql



  • Total 46K
  • Win 33K
  • Mac 6K
  • Linux 7K
Apr 21 Apr 20 Apr 19 Apr 18 Apr 17 Apr 16 Apr 15 Apr 14 Apr 13 Apr 12 Apr 11 Apr 10 Apr 9 Apr 8 Apr 7 Apr 6 Apr 5 Apr 4 Apr 3 Apr 2 Apr 1 Mar 31 Mar 30 Mar 29 Mar 28 Mar 27 Mar 26 Mar 25 Mar 24 Mar 23 Mar 22 Mar 21 Mar 20 Mar 19 Mar 18 Mar 17 Mar 16 Mar 15 Mar 14 Mar 13 Mar 12 Mar 11 Mar 10 Mar 9 Mar 8 Mar 7
Windows 0 3 0 3 1 0 2 1 3 1 2 5 4 3 3 0 0 1 1 7 0 0 3 3 0 5 0 2 2 2 3 5 2 5 0 0 3 4 4 1 1 2 0 1 0 3
Mac 0 1 0 2 1 0 2 0 0 0 0 0 0 0 0 1 0 2 1 0 0 1 0 1 1 0 1 0 0 0 0 0 0 0 1 0 0 1 0 1 0 0 0 0 0 0
Linux 0 2 0 0 1 0 1 0 1 1 0 1 0 1 0 1 0 0 1 2 0 0 0 1 2 1 0 1 0 1 0 0 0 1 1 0 0 0 0 0 0 2 1 0 2 0



MySQL Snippets - Sublime Plugin

A sublime plugin complete with MySQL snippets

Quick review: http://youtu.be/rQoqbEiFNoU

Feel free to let me know what else you want added via:

What's included - contents


There are 3 methods for installing this plugin.

  1. Search for “MySQL Snippets” via the “Package Control: Install Packages” menu. Note: If you don't have Sublime Package Control installed, you can find out how to install it here https://sublime.wbond.net/installation

  2. Clone the repository into your Sublime Text 2/3 packages directory. git clone https://github.com/ancor-dev/sublime-sql-snippets.git

  3. Download the .zip file and unzip it into your Sublime Text 2/3 packages directory. Note: You can find your Sublime Text 2/3 packages directory by going to Preferences > Browse Packages.


Snippet Code Description
s-db create a new database
s-db-drop delete the database


Snippet Code Description
s-table create simple table with INT primary key
s–table create simple table with INT primary key, but first remove the old table
s-table-tmp create simple temporary table with engine=memory
s–table-tmp the same, but first remove the old table

s-many-many - Very powerful snippet! Make table for relation many-to-many, make two foreign key constrain, and two indexes in it and make two indexes in corresponding tables

Create Table components

Snippet Code Description
s-fk make foreign key constrain for table creation
s–fk make foreign key constrain for table creation with corresponding indexes
s-idx make default index for table creation
s-idx-txt make FULLTEXT index for table creation
s-pk make primary key
s-uk make unique key


Snippet Code Description
s-i insert multirow
s-ione insert one row
s-ifrom isert data from a sample(other table or database)


Snippet Code Description
s-s default select for extending with help query-options
s-sone select one row by where condition
s-sinline inline select for simple a sample
s-smin inline select for search min value
s-smax inline select for search max value
s-scount inline select for count rows in the table
s-ss select a value SELECT '...';
s-sv select a variable SELECT;

Query options


Snippet Code Description
s- the entity. Like `table`.`column`
s– the entity with a comma. Like , `table`.`column`
s-alias the entity with alias. Like `table`.`column` AS `my_col`
s–alias the same with comma. Like , `table`.`column` AS `my_col`
s-and a part of conditions AND ( ... )
s-or a part of conditions OR ( ... )
s–and a part of conditions with expression AND ( `col` = `col2` )
s–or a part of conditions with expression OR ( `col` = `col2` )
s-e an expression ( `col` = `col2` )


Snippet Code Description
s-f from statement like FROM `table` AS `alias`
s-j inner join statement
s-jleft left join statement
s-jright right join statement
s-w where statement
s-o order by statement
s-l limi statement
s-g group by statement
s-h having statement
s-u union statement


Snippet Code Description
s-u default update snippet with where condition


Snippet Code Description
s-d default delete snippet with where condition

Alter - modify structure

All alter snippets begining from s-alter-* prefix, like s-alter-add.


Snippet Code Description
add add a column to table at the last column
add-first add a column to table at the first column
add-after add a column to table after someone column
auto-increment change auto_increment counter value
change change the column(rename or change type)
modify modify the column(change type and column order)
drop drop the column from the table


Snippet Code Description
idx add an index to the table
idx-drop drop the index from the table
order sort the table by column(yes it indeed possible!)
table-rename rename the table
table-charset change table charset and collate
db-charset change database charset and collate
fk add foreign key to the table
-fk add foreign key to the table with index
fk-drop drop the foreign key from the table
uk add unique key to exists table


Snippet Code Description
s-trig create new trigger
s–trig replace trigger(drop and create new)
s-trig-list list triggers for table
s–trig-list list triggers for table(also specify DB)
s-trig-drop drop the trigger


Snippet Code Description
s-proc create new storage procedure
s–proc replace procedure(drop and create new)
s-proc-drop drop the storage procedure
s-proc-list show stored procedures list(only current database)


Snippet Code Description
s-func create new function
s–func replace function(drop and create new)
s-func-drop drop the function
s-func-list show list of user-defined functions(only current database)


Snippet Code Description
s-hcols details of the table (SHOW FULL COLUMNS FROM ...)
s-hcreate show command for creating the table
s-hidx show indexes for the table
s-hrel show relations of a table (using information_schema)



Snippet Code Description
s-dec declare a variable
s–dec declare a variable with default value
s-dec-s declare a string(VARCHAR) variable
s–dec-s declare a string(VARCHAR) variable with default value
s-dec-cur declare a cursor


Snippet Code Description
s-if create if statement
s–if create if else statement


Snippet Code Description
s-case CASE var_name WHEN 'value' THEN ... END CASE - value based
s-case-w WHEN 'value' THEN ... ; - value based
s-case-wb WHEN 'value' THEN BEGIN ... END; - value based
s–case CASE WHEN var_name = 'value' THEN ... END CASE - condition based
s–case-w WHEN var_name = 'value' THEN ... ; - condition based
s–case-wb WHEN var_name = 'value' THEN BEGIN ... END; - condition based


Snippet Code Description
s-loop LOOP ... END LOOP - Complex snippet. With additional logic!
s-repeat REPEAT ... UNTIL ... END REPEAT construct
s–repeat REPEAT BEGIN ... END; UNTIL ... END REPEAT construct


Snippet Code Description
s-cur powerful complex snippet! Makes ready to use cursor


Snippet Code Description
s-user-list list all users
s-user-add create a new user
s–user-add create a new user with a password (short access s--u)
s-user-add-hash create new user with a password by hash
s-user-drop remove user
s-user-pwd change user password


Snippet Code Description
s-priv-refresh command flush priveleges
s-priv-add add some privileges to user
s-priv-add-all add all privileges to user
s-priv-drop remove some privileges from user
s-priv-drop-all remove all privileges from user
s-priv-list show list of user privileges


Snippet Code Description
s-delim make delimiter $$ statement and at the end delimiter ;
s-utc select current timestamp