让editplus支持sql编辑

来源：互联网发布：影视鉴赏网络课答案16 编辑：程序博客网时间：2024/06/08 08:36

让editplus支持sql编辑

平时比较喜欢用editplus编辑器，用它来写Java程序，HTML程序和JSP程序，都很方便，但是最近我处于习惯用editplus来编写SQL存储过程的时候，就觉得很不舒服，主要是它不认SQL关键字，后来我发现这个问题其实是可以解决的。

首先就是要自己编写一段代码，存为.stx 文件（例如sql.stx），然后在editplus的菜单栏Tools(工具)-> Configure User Tools(配置用户工具)->Files(文件)->Setting &syntax(设置和语法),点add(添加)按钮，在 description(输入文件类型说明)栏位填上sql,file Extensions(文件扩展名)栏位也填上sql,如果有多个扩展名，之间用“；”隔开（例如：sql; db2）,然后在syntax file栏位填上sql.stx文件所在的路径，

我的是在D:\tools\editplus\SQL.stx，这样就可以了。

下面是我的sql.stx文件源码：

#TITLE=SQL  ; SQL syntax file written by xxx   #DELIMITER=,(){}[]-+*%/='~!&|<>?:;.  #QUOTATION1='  #CONTINUE_QUOTE=n  #LINECOMMENT=--  #LINECOMMENT2=#  #COMMENTON=/*  #COMMENTOFF=*/  #ESCAPE=\  #SPECIAL_STX=SQL   #KEYWORD=SQL Tags  ;var type  sql_variant  datetime  smalldatetime  float  real  datedecimal  moneynumber  smallmoney  bigint int  smallint  tinyint  bit  ntext  text image integer  timestamp  uniqueidentifier nvarchar nchar varchar varchar2char  varbinary  binary ;database entities COLUMN CONSTRAINTCURSOR DATABASE  INDEXTABLE 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  ASCAUTHORIZATIONAVG BACKUP BEGIN  BETWEEN BREAK  BROWSE BULK BY CASCADECASE CHARACTERCHECK  CHECKPOINTCLOSE  CLUSTERED COALESCE COMMIT COMMENT  COMMITTED COMPUTE CONFIRM  CONNECT CONTAINS  CONTAINSTABLECONTINUE CONTROLROWCONVERT  COUNT  CREATECROSS CURRENT  CURRENT_DATECURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER DBCC  DEALLOCATE DECLARE DEFAULT DELETE  DENY  DESC DISK DISTINCT DISTRIBUTED DOUBLE DROP  DUMMY DUMP  ELSE END ERRLVLERROREXIT ESCAPE EXCEPT  EXECEXECUTE  EXISTS EXIT  FETCH FILE  FILLFACTORFLOPPYFOR FOREIGN FREETEXT FREETEXTTABLEFROM FULL GOTO  GRANT GROUP  HAVING  HOLDLOCK IDENTITYIDENTITY_INSERTIDENTITYCOLIFIN INNER INSERTINTERSECTINTO IS ISOLATION JOIN KEY  KILL LEFTLEVEL LIKE  LINENOLOAD MAX  MODIFYMIN MIRROREXIT NATIONAL NOCHECKNONCLUSTERED  NOT NULL  NULLIF OFOFF OFFSETSON ONCEONLY OPENOPENDATASOURCE  OPENQUERY  OPENROWSETOPTION OR  ORDEROUTEROVER PERCENTPERMPERMANENTPIPE PLAN PRECISION PREPARE  PRIMARY PRINT PRIVILEGESPROC  PROCEDUREPROCESSEXITPUBLIC RAISERROR READ  READTEXT RECONFIGUREREFERENCES RENAMEREPEATABLE REPLICATION RESTORE  RESTRICT RETURN REVOKE  RIGHT  ROLLBACK ROWCOUNT ROWGUIDCOL RULE SAVESCHEMASELECT  SERIALIZABLE  SESSION_USER SET SETUSER SHUTDOWN SOME  STATISTICS  SUBSTRSUM SYSTEM_USER TABLE TAPE TEMP TEMPORARY  TEXTSIZE THEN  TIMESTAMP TO TOP TRAN TRANSACTION TRIGGERTRUNCATE TSEQUAL  UNCOMMITTED UNION  UNIQUEUPDATE UPDATETEXTUSE  USERUSING VALUES VARYING  WAITFOR WHEN  WHERE WHILE WITH WORK WRITETEXT ;MySQL Features  AUTO_INCREMENT

0 0