让EditPlus支持SQL高亮提示
将文件放在一个确定的位置,不要放在桌面这些临时位置。然后在 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 PRINT 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