atom-mysql-snippets
A collection of MySQL commands for optimizing modern MySQL development productivity.
Atom MySQL Snippets
A collection of MySQL commands for optimizing modern MySQL development productivity.
Install
$ apm install atom-mysql-snippets
Contributing/Suggestions
Feel free to let me know (link) what else can be improved/added or you can also submit a PR.
Snippets Overview
- Database
- Table
- Table components
- Insert
- Select
- Query options
- Update
- Delete
- Alter
- Trigger
- Procedure
- Function
- Constructions
- Show
- User
- Privileges
- Other
Database
Snippet Code | Description |
---|---|
s-db | create a new database |
s-db-drop | delete the database |
Table
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 |
Insert
Snippet Code | Description |
---|---|
s-i | insert multirow |
s-ione | insert one row |
s-ifrom | isert data from a sample(other table or database) |
Select
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
Expressions
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` ) |
Statements
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 |
Update
Snippet Code | Description |
---|---|
s-u | default update snippet with where condition |
Delete
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
.
Columns
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 |
Other
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 |
Trigger
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 |
Procedure
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) |
Function
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) |
Show
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 ) |
Constructions
Declare
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-h | declare a CONTINUE HANDLER FOR SQLSTATE |
s-dec-cur | declare a cursor |
Condition
Snippet Code | Description |
---|---|
s-if | create if statement |
s--if | create if else statement |
Case
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 |
Loops
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 |
Other
Snippet Code | Description |
---|---|
s-cur | powerful complex snippet! Makes ready to use cursor |
User
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 |
Privileges
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 |
Other
Snippet Code | Description |
---|---|
s-delim | make delimiter $$ statement and at the end delimiter ; |
s-utc | select current timestamp |
Contact Me
Credits
- Idleberg for his Atomizer package that helped me convert Sublime snippets into Atom's format.
- ancor-dev for his sublime-sql-snippets package, which I used for the snippets in this package.