Editplus
首先新建一个文本文档,并打开它
在打开的文档中添加如下内容:(内容较长,建议复制)#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 typesql_variantdatetimesmalldatetimefloatrealdecimalmoneysmallmoneybigintintsmallinttinyintbitntexttextimageintegertimestampuniqueidentifiernvarcharncharvarcharcharvarbinarybinary;database entitiesCOLUMNCONSTRAINTCURSORDATABASEINDEXTABLEVIEWENGINE#KEYWORD=Entities;index typeBTREEHASH;character setutf8latine;MySQL featuresInnoDB#KEYWORD=Reserved words;CommonADDALLALTERANDANYASASCAUTHORIZATIONAVGBACKUPBEGINBETWEENBREAKBROWSEBULKBYCASCADECASECHARACTERCHECKCHECKPOINTCLOSECLUSTEREDCOALESCECOMMITCOMMENTCOMMITTEDCOMPUTECONFIRMCONNECTCONTAINSCONTAINSTABLECONTINUECONTROLROWCONVERTCOUNTCREATECROSSCURRENTCURRENT_DATECURRENT_TIMECURRENT_TIMESTAMPCURRENT_USERDBCCDEALLOCATEDECLAREDEFAULTDELETEDENYDESCDISKDISTINCTDISTRIBUTEDDOUBLEDROPDUMMYDUMPELSEENDERRLVLERROREXITESCAPEEXCEPTEXECEXECUTEEXISTSEXITFETCHFILEFILLFACTORFLOPPYFORFOREIGNFREETEXTFREETEXTTABLEFROMFULLGOTOGRANTGROUPHAVINGHOLDLOCKIDENTITYIDENTITY_INSERTIDENTITYCOLIFININNERINSERTINTERSECTINTOISISOLATIONJOINKEYKILLLEFTLEVELLIKELINENOLOADMAXMINMIRROREXITNATIONALNOCHECKNONCLUSTEREDNOTNULLNULLIFOFOFFOFFSETSONONCEONLYOPENOPENDATASOURCEOPENQUERYOPENROWSETOPTIONORORDEROUTEROVERPERCENTPERMPERMANENTPIPEPLANPRECISIONPREPAREPRIMARYPRINTPRIVILEGESPROCPROCEDUREPROCESSEXITPUBLICRAISERRORREADREADTEXTRECONFIGUREREFERENCESREPEATABLEREPLICATIONRESTORERESTRICTRETURNREVOKERIGHTROLLBACKROWCOUNTROWGUIDCOLRULESAVESCHEMASELECTSERIALIZABLESESSION_USERSETSETUSERSHUTDOWNSOMESTATISTICSSUBSTRSUMSYSTEM_USERTABLETAPETEMPTEMPORARYTEXTSIZETHENTIMESTAMPTOTOPTRANTRANSACTIONTRIGGERTRUNCATETSEQUALUNCOMMITTEDUNIONUNIQUEUPDATEUPDATETEXTUSEUSERUSINGVALUESVARYINGWAITFORWHENWHEREWHILEWITHWORKWRITETEXT;MySQL FeaturesAUTO_INCREMENT
如图,添加完成后,关闭窗口并保存,然后将文本文档的文件名命名为“sql.stx”(请确保你的电脑已经设置不隐藏文件扩展名)
将这个 sql.stx 文件拖曳进你的 editplus 软件安装目录中,如图
打开 editplus 的“参数设置”菜单,打开后点击“添加”按钮
输入 SQL,并确定
点击如图所示的“三个点”按钮来添加语法文件,也就是刚才我们拖曳进去的 sql.stx 文件
添加好后,在“文件扩展名”一栏中输入“sql”,即对打开的扩展名为 sql 的文件进行高亮显示
此时我们再随便用 editplus 打开一个 sql 文件都可以看到语法高亮了
语法高亮的关键字和颜色都可以自定义