package_name: "sql" package_title: "sql Package" package_desc: "A package to get sql code snippets" package_version: "0.1.0" package_author: "yanming zhang" package_repo: "https://github.com/zhangymPerson/espanso-package-sql"
An package to get sql command code snippets
For more information about espanso packages, read the documentation.
Usage
Available replacements:
DML(Data Manipulation Language)
| replacement | output | description |
|---|---|---|
:select: | select * from table_name limit 100; | |
:where: | select * from table_name where condition; | |
:count: | select count(*) from table_name; | |
:limit: | select * from table_name limit 100; | |
:groupby: | select column from table_name group by column; | |
:leftjoin: | select * from table_name left join table_name2 on condition; | |
:insert: | insert into table_name (column1, column2) values (value1, value2); | |
:update: | update table_name set column1 = value1, column2 = value2 where condition; | |
:delete: | delete from table_name where condition; |
DDL(Data Definition Language)
- default use mysql ddl
| replacement | output | description |
|---|---|---|
:create: | create table table_name; | mysql |
:alter: | alter table table_name; | mysql |
:drop: | drop table table_name; | |
:truncate: | truncate table table_name; |
other
mysql
| replacement | output | description |
|---|---|---|
:use: | use database; | |
:showdb: | show databases; | |
:showtb: | show tables; | |
:desc: | desc table_name; |