验证sql保留字工具

来源：Readlog.cn 时间：2008-05-15 12:34:00　

验证关键词是否为sql保留字的在线工具：

<html> <head><title>验证sql保留字 - asp之家</title> <script type="text/javascript"> function isSql(objID) { var i,msg; var str=document.getElementById(objID).value.toLowerCase(); var w=",action,add,aggregate,all,alter,after,and,as,asc,avg,avg_row_length,auto_increment,between,bigint,bit,binary,blob,bool,both,by,cascade,case,char,character,change,check,checksum,column,columns,comment,constraint,create,cross,current_date,current_time,current_timestamp,data,database,databases,date,datetime,day,day_hour,day_minute,day_second,dayofmonth,dayofweek,dayofyear,dec,decimal,default,delayed,delay_key_write,delete,desc,describe,distinct,distinctrow,double,drop,end,else,escape,escaped,enclosed,enum,explain,exists,fields,file,first,float,float4,float8,flush,foreign,from,for,full,function,global,grant,grants,group,having,heap,high_priority,hour,hour_minute,hour_second,hosts,identified,ignore,in,index,infile,inner,insert,insert_id,int,integer,interval,int1,int2,int3,int4,int8,into,if,is,isam,join,key,keys,kill,last_insert_id,leading,left,length,like,lines,limit,load,local,lock,logs,long,longblob,longtext,low_priority,max,max_rows,match,mediumblob,mediumtext,mediumint,middleint,min_rows,minute,minute_second,modify,month,monthname,myisam,natural,numeric,no,not,null,on,optimize,option,optionally,or,order,outer,outfile,pack_keys,partial,password,precision,primary,procedure,process,processlist,privileges,read,real,references,reload,regexp,rename,replace,restrict,returns,revoke,rlike,row,rows,second,select,set,show,shutdown,smallint,soname,sql_big_tables,sql_big_selects,sql_low_priority_updates,sql_log_off,sql_log_update,sql_select_limit,sql_small_result,sql_big_result,sql_warnings,straight_join,starting,status,string,table,tables,temporary,terminated,text,then,time,timestamp,tinyblob,tinytext,tinyint,trailing,to,type,use,using,unique,unlock,unsigned,update,usage,values,varchar,variables,varying,varbinary,with,write,when,where,year,year_month,zerofill,"; msg=w.indexOf(","+str+",")!=-1?"":"不"; alert(str+msg); } </script> </head> <body> <h3>sql保留字验证</h3><hr> 请输入保留字： <input id="wd" type="text" size=8> <input type="button" value="提交" onclick="isSql('wd');"> </body> </html>

标签：sql,工具,保留字

投稿

验证sql保留字工具

猜你喜欢

在windows下 1045 access denied for user

asp中获取当前月份距离以前某个时间的月份数

css教程–十步学会用css建站(全)[翻译]

深入剖析SQL Server的六种数据移动方法

设计角色的分工和配合

ASP四级连动下拉列表程序段

oracle 存储过程和触发器复制数据

转换字符串单词的第一个字母为大写

MySQL数据库性能优化之索引优化

为什么JavaScript中正则表达式的test方法会出错？

【总结】ASP如何获取访客真实的IP地址

终结IE6下背景图片闪烁问题

交互设计实用指南系列(10)—别让我思考

10分钟学会Google Map API （二）

SQL Server 2000 作数据库服务器的优点

如何在MySQL查询结果集中得到记录行号

微软建议的ASP性能优化28条守则(7)

Oracle中Union与Union All的区别(适用多个数据库)

脆弱的用户体验

SQL server使用自定义函数以及游标