将文件放在一个确定的位置,不要放在桌面这些临时位置。然后在 EditPlus 的菜单栏选择 工具(T) -> 配置用户工具(C)
选择左边“类别”中的 文件 -> 设置&语法 ,点击右边“添加”按钮。类型名称用 SQL ,还需要填写扩展名和语法文件。其中扩展名就写 sql ,不要加点;语法文件通过 ... 按钮选中即可。点击确定,然后最好能重启 EditPlus 。
如此,EditPlus 对 SQL 的语法识别即刻生效。
附:sql.stx
- #TITLE=SQL
- ; SQL syntax file written by Shane Loo Li at 2012-9-12 Wednesday
- ; This file is required for EditPlus to run correctly.
- #DELIMITER=,(){}[]-+*%/='~!&|<>?:;.
- #QUOTATION1='
- #CONTINUE_QUOTE=n
- #LINECOMMENT=--
- #COMMENTON=/*
- #COMMENTOFF=*/
- #ESCAPE=\
- #SPECIAL_STX=SQL
- #KEYWORD=SQL Tags
- ;var type
- sql_variant
- datetime
- smalldatetime
- float
- real
- decimal
- money
- smallmoney
- bigint
- int
- smallint
- tinyint
- bit
- ntext
- text
- image
- integer
- timestamp
- uniqueidentifier
- nvarchar
- nchar
- varchar
- char
- varbinary
- binary
- ;database entities
- COLUMN
- CONSTRAINT
- CURSOR
- DATABASE
- INDEX
- TABLE
- VIEW
- ENGINE
- #KEYWORD=Entities
- ;index type
- BTREE
- HASH
- ;character set
- utf8
- latine
- ;MySQL features
- InnoDB
- #KEYWORD=Reserved words
- ;Common
- ADD
- ALL
- ALTER
- AND
- ANY
- AS
- ASC
- AUTHORIZATION
- AVG
- BACKUP
- BEGIN
- BETWEEN
- BREAK
- BROWSE
- BULK
- BY
- CASCADE
- CASE
- CHARACTER
- CHECK
- CHECKPOINT
- CLOSE
- CLUSTERED
- COALESCE
- COMMIT
- COMMENT
- COMMITTED
- COMPUTE
- CONFIRM
- CONNECT
- CONTAINS
- CONTAINSTABLE
- CONTINUE
- CONTROLROW
- CONVERT
- COUNT
- CREATE
- CROSS
- CURRENT
- CURRENT_DATE
- CURRENT_TIME
- CURRENT_TIMESTAMP
- CURRENT_USER
- DBCC
- DEALLOCATE
- DECLARE
- DEFAULT
- DELETE
- DENY
- DESC
- DISK
- DISTINCT
- DISTRIBUTED
- DOUBLE
- DROP
- DUMMY
- DUMP
- ELSE
- END
- ERRLVL
- ERROREXIT
- ESCAPE
- EXCEPT
- EXEC
- EXECUTE
- EXISTS
- EXIT
- FETCH
- FILE
- FILLFACTOR
- FLOPPY
- FOR
- FOREIGN
- FREETEXT
- FREETEXTTABLE
- FROM
- FULL
- GOTO
- GRANT
- GROUP
- HAVING
- HOLDLOCK
- IDENTITY
- IDENTITY_INSERT
- IDENTITYCOL
- IF
- IN
- INNER
- INSERT
- INTERSECT
- INTO
- IS
- ISOLATION
- JOIN
- KEY
- KILL
- LEFT
- LEVEL
- LIKE
- LINENO
- LOAD
- MAX
- MIN
- MIRROREXIT
- NATIONAL
- NOCHECK
- NONCLUSTERED
- NOT
- NULL
- NULLIF
- OF
- OFF
- OFFSETS
- ON
- ONCE
- ONLY
- OPEN
- OPENDATASOURCE
- OPENQUERY
- OPENROWSET
- OPTION
- OR
- ORDER
- OUTER
- OVER
- PERCENT
- PERM
- PERMANENT
- PIPE
- PLAN
- PRECISION
- PREPARE
- PRIMARY
- PRIVILEGES
- PROC
- PROCEDURE
- PROCESSEXIT
- PUBLIC
- RAISERROR
- READ
- READTEXT
- RECONFIGURE
- REFERENCES
- REPEATABLE
- REPLICATION
- RESTORE
- RESTRICT
- RETURN
- REVOKE
- RIGHT
- ROLLBACK
- ROWCOUNT
- ROWGUIDCOL
- RULE
- SAVE
- SCHEMA
- SELECT
- SERIALIZABLE
- SESSION_USER
- SET
- SETUSER
- SHUTDOWN
- SOME
- STATISTICS
- SUBSTR
- SUM
- SYSTEM_USER
- TABLE
- TAPE
- TEMP
- TEMPORARY
- TEXTSIZE
- THEN
- TIMESTAMP
- TO
- TOP
- TRAN
- TRANSACTION
- TRIGGER
- TRUNCATE
- TSEQUAL
- UNCOMMITTED
- UNION
- UNIQUE
- UPDATE
- UPDATETEXT
- USE
- USER
- USING
- VALUES
- VARYING
- WAITFOR
- WHEN
- WHERE
- WHILE
- WITH
- WORK
- WRITETEXT
- ;MySQL Features
- AUTO_INCREMENT