Mysql 保留字（关键字）检查

最新推荐文章于 2024-06-28 11:43:37 发布
刘贵庆
最新推荐文章于 2024-06-28 11:43:37 发布
阅读量703
点赞数
分类专栏：前端 js 文章标签： mysql mysql保留字 mysql关键字
本文为博主原创文章，未经博主允许请勿转载，切勿用于商业用途，若有引用请加原文链接。
本文链接：https://blog.csdn.net/xysxlgq/article/details/122030221
版权
前端同时被 2 个专栏收录
56 篇文章 0 订阅
订阅专栏
36 篇文章 1 订阅
订阅专栏
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>Mysql 保留字（关键字）检查</title>
    <style type="text/css">input{outline-style:none;border:1px solid #ccc;border-radius:3px;padding:13px 14px;width:620px;font-size:14px;font-weight:700;font-family:"Microsoft soft";}input:focus{border-color:#66afe9;outline:0;-webkit-box-shadow:inset 0 1px 1px rgba(0,0,0,.075),0 0 8px rgba(102,175,233,.6);box-shadow:inset 0 1px 1px rgba(0,0,0,.075),0 0 8px rgba(102,175,233,.6)}.button{background-color:#2729df;border:2px solid #0427cb;color:#FFFFFF;text-align:center;width:80px;height:40px;font-size:22px;}.button:hover{background-color:#2d30f7;border:2px solid #0427cb;color:#FFFFFF;text-align:center;width:80px;height:40px;font-size:22px;}.maindiv{margin-left:150px;margin-right:150px;height:750px;}.tcenter{margin-top:20px;text-align:center;}.ta{float:left;margin-top:6px;text-align:center;font-size:x-large;margin-left:38%;}</style>
</head>
<body>
<div class="maindiv"><div style="margin-top:45px;text-align:center;"><H2>Mysql保留字（关键字）检查</H2></div><div class="tcenter"><input id="it"/>&emsp;<button class="button"onclick="select()">搜索</button></div><div id="tips"style="margin-top: 30px;"></div></div>
<script type="text/javascript">
    function select() {
        var v = "", n = "", yet = "", tf = "",inputvs="";var tip = document.getElementById('tips');var inputv = document.getElementById("it").value;
        var arr = ['ACCESSIBLE (R)','ADD (R)','AGGREGATE','ALTER (R)','ANALYZE (R)','AS (R)','ASENSITIVE (R)','AUTO_INCREMENT','BACKUP','BETWEEN (R)','BINLOG','BLOCK','BOTH (R)','BYTE','CASCADE (R)','CATALOG_NAME','CHANGED','CHARACTER (R)','CHECKSUM','CLIENT','CODE','COLUMN (R)','COLUMN_NAME','COMMITTED','COMPRESSED','CONDITION (R)','CONSTRAINT (R)','CONSTRAINT_SCHEMA','CONTINUE (R)','CREATE (R)','CURRENT','CURRENT_TIMESTAMP (R)','CURSOR_NAME','DATABASES (R)','DATETIME','DAY_MICROSECOND (R)','DEALLOCATE','DECLARE (R)','DEFINER','DELETE (R)','DES_KEY_FILE','DIRECTORY','DISK','DIV (R)','DROP (R)','DUPLICATE','ELSE (R)','ENCLOSED (R)','ENDS','ENUM','ESCAPE','EVENTS','EXECUTE','EXPANSION','EXPORT','FALSE (R)','FETCH (R)','FILE_BLOCK_SIZE[f]','FIXED','FLOAT8 (R)','FOR (R)','FORMAT','FULL','GENERAL','GEOMETRYCOLLECTION','GLOBAL','GROUP (R)','HASH','HIGH_PRIORITY (R)','HOUR','HOUR_SECOND (R)','IGNORE (R)','IN (R)','INFILE (R)','INOUT (R)','INSERT_METHOD','INT (R)','INT3 (R)','INTEGER (R)','INVOKER','IO_BEFORE_GTIDS (R)','IS (R)','ITERATE (R)','KEY (R)','KILL (R)','LEADING (R)','LEFT (R)','LIKE (R)','LINES (R)','LOAD (R)','LOCALTIMESTAMP (R)','LOGFILE','LONGBLOB (R)','LOW_PRIORITY (R)','MASTER_BIND (R)','MASTER_HEARTBEAT_PERIOD','MASTER_LOG_POS','MASTER_RETRY_COUNT','MASTER_SSL_CA','MASTER_SSL_CIPHER','MASTER_SSL_KEY','MASTER_USER','MAX_CONNECTIONS_PER_HOUR','MAX_SIZE','MAX_USER_CONNECTIONS','MEDIUMINT (R)','MERGE','MIDDLEINT (R)','MINUTE_MICROSECOND (R)','MOD (R)','MODIFY','MULTIPOINT','MYSQL_ERRNO','NATIONAL','NDB','NEW','NODEGROUP','NOT (R)','NULL (R)','NVARCHAR','ON (R)','OPEN','OPTION (R)','OR (R)','OUTER (R)','PACK_KEYS','PARSE_GCOL_EXPR[s]','PARTITIONING','PHASE','PLUGIN_DIR','PORT','PREPARE','PRIMARY (R)','PROCESSLIST','PROXY','QUERY','READ (R)','READ_WRITE (R)','RECOVER','REDUNDANT','RELAY','RELAY_LOG_POS','RELOAD','REORGANIZE','REPEATABLE','REPLICATE_DO_TABLE[v]','REPLICATE_REWRITE_DB[y]','REPLICATION','RESIGNAL (R)','RESUME','RETURNS','RIGHT (R)','ROLLUP','ROW','ROW_FORMAT','SCHEDULE','SCHEMA_NAME','SECURITY','SEPARATOR (R)','SERVER','SHARE','SIGNAL (R)','SLAVE','SNAPSHOT','SONAME','SPATIAL (R)','SQLEXCEPTION (R)','SQL_AFTER_GTIDS','SQL_BIG_RESULT (R)','SQL_CALC_FOUND_ROWS (R)','SQL_THREAD','SQL_TSI_MINUTE','SQL_TSI_SECOND','SSL (R)','STARTING (R)','STATS_PERSISTENT','STOP','STRAIGHT_JOIN (R)','SUBJECT','SUPER','SWITCHES','TABLESPACE','TEMPORARY','TEXT','TIME','TIMESTAMPDIFF','TINYTEXT (R)','TRANSACTION','TRUE (R)','TYPES','UNDO (R)','UNICODE','UNIQUE (R)','UNSIGNED (R)','UPGRADE','USER','USING (R)','UTC_TIMESTAMP (R)','VALUES (R)','VARCHARACTER (R)','VIEW','WARNINGS','WHEN (R)','WITH (R)','WRAPPER','XA','XOR (R)','AFTER','ALGORITHM','ALWAYS[b]','AND (R)','ASC (R)','AT','AVG','BEFORE (R)','BIGINT (R)','BIT','BOOL','BTREE','CACHE','CASCADED','CHAIN','CHANNEL[c]','CHARSET','CIPHER','CLOSE','COLLATE (R)','COLUMNS','COMMENT','COMPACT','COMPRESSION[d]','CONNECTION','CONSTRAINT_CATALOG','CONTAINS','CONVERT (R)','CROSS (R)','CURRENT_DATE (R)','CURRENT_USER (R)','DATA','DATAFILE','DAY','DAY_MINUTE (R)','DEC (R)','DEFAULT (R)','DELAYED (R)','DESC (R)','DETERMINISTIC (R)','DISABLE','DISTINCT (R)','DO','DUAL (R)','DYNAMIC','ELSEIF (R)','ENCRYPTION[e]','ENGINE','ERROR','ESCAPED (R)','EVERY','EXISTS (R)','EXPIRE','EXTENDED','FAST','FIELDS','FILTER[g]','FLOAT (R)','FLUSH','FORCE (R)','FOUND','FULLTEXT (R)','GENERATED[i] (R)','GET (R)','GRANT (R)','GROUP_REPLICATION[j]','HAVING (R)','HOST','HOUR_MICROSECOND (R)','IDENTIFIED','IGNORE_SERVER_IDS','INDEX (R)','INITIAL_SIZE','INSENSITIVE (R)','INSTALL','INT1 (R)','INT4 (R)','INTERVAL (R)','IO','IO_THREAD','ISOLATION','JOIN (R)','KEYS (R)','LANGUAGE','LEAVE (R)','LESS','LIMIT (R)','LINESTRING','LOCAL','LOCK (R)','LOGS','LONGTEXT (R)','MASTER','MASTER_CONNECT_RETRY','MASTER_HOST','MASTER_PASSWORD','MASTER_SERVER_ID','MASTER_SSL_CAPATH','MASTER_SSL_CRL','MASTER_SSL_VERIFY_SERVER_CERT (R)','MATCH (R)','MAX_QUERIES_PER_HOUR','MAX_STATEMENT_TIME[n]','MEDIUM','MEDIUMTEXT (R)','MESSAGE_TEXT','MIGRATE','MINUTE_SECOND (R)','MODE','MONTH','MULTIPOLYGON','NAME','NATURAL (R)','NDBCLUSTER','NEXT','NONBLOCKING[p]','NO_WAIT','NUMBER','OFFSET','ONE','OPTIMIZE (R)','OPTIONALLY (R)','ORDER (R)','OUTFILE (R)','PAGE','PARTIAL','PARTITIONS','PLUGIN','POINT','PRECEDES[t]','PRESERVE','PRIVILEGES','PROFILE','PURGE (R)','QUICK','READS (R)','REAL (R)','REDOFILE','REFERENCES (R)','RELAYLOG','RELAY_THREAD','REMOVE','REPAIR','REPLACE (R)','REPLICATE_IGNORE_DB[w]','REPLICATE_WILD_DO_TABLE[z]','REQUIRE (R)','RESTORE','RETURN (R)','REVERSE','RLIKE (R)','ROTATE[ab]','ROWS','RTREE','SCHEMA (R)','SECOND','SELECT (R)','SERIAL','SESSION','SHOW (R)','SIGNED','SLOW','SOCKET','SOUNDS','SPECIFIC (R)','SQLSTATE (R)','SQL_AFTER_MTS_GAPS','SQL_BUFFER_RESULT','SQL_NO_CACHE','SQL_TSI_DAY','SQL_TSI_MONTH','SQL_TSI_WEEK','STACKED','STARTS','STATS_SAMPLE_PAGES','STORAGE','STRING','SUBPARTITION','SUSPEND','TABLE (R)','TABLE_CHECKSUM','TEMPTABLE','THAN','TIMESTAMP','TINYBLOB (R)','TO (R)','TRIGGER (R)','TRUNCATE','UNCOMMITTED','UNDOFILE','UNINSTALL','UNKNOWN','UNTIL','USAGE (R)','USER_RESOURCES','UTC_DATE (R)','VALIDATION[ad]','VARBINARY (R)','VARIABLES','VIRTUAL[ae] (R)','WEEK','WHERE (R)','WITHOUT[af]','WRITE (R)','XID[ag]','YEAR','ACTION','AGAINST','ALL (R)','ANALYSE','ANY','ASCII','AUTOEXTEND_SIZE','AVG_ROW_LENGTH','BEGIN','BINARY (R)','BLOB (R)','BOOLEAN','BY (R)','CALL (R)','CASE (R)','CHANGE (R)','CHAR (R)','CHECK (R)','CLASS_ORIGIN','COALESCE','COLLATION','COLUMN_FORMAT','COMMIT','COMPLETION','CONCURRENT','CONSISTENT','CONSTRAINT_NAME','CONTEXT','CPU','CUBE','CURRENT_TIME (R)','CURSOR (R)','DATABASE (R)','DATE','DAY_HOUR (R)','DAY_SECOND (R)','DECIMAL (R)','DEFAULT_AUTH','DELAY_KEY_WRITE','DESCRIBE (R)','DIAGNOSTICS','DISCARD','DISTINCTROW (R)','DOUBLE (R)','DUMPFILE','EACH (R)','ENABLE','END','ENGINES','ERRORS','EVENT','EXCHANGE','EXIT (R)','EXPLAIN (R)','EXTENT_SIZE','FAULTS','FILE','FIRST','FLOAT4 (R)','FOLLOWS[h]','FOREIGN (R)','FROM (R)','FUNCTION','GEOMETRY','GET_FORMAT','GRANTS','HANDLER','HELP','HOSTS','HOUR_MINUTE (R)','IF (R)','IMPORT','INDEXES','INNER (R)','INSERT (R)','INSTANCE[k]','INT2 (R)','INT8 (R)','INTO (R)','IO_AFTER_GTIDS (R)','IPC','ISSUER','JSON[l]','KEY_BLOCK_SIZE','LAST','LEAVES','LEVEL','LINEAR (R)','LIST','LOCALTIME (R)','LOCKS','LONG (R)','LOOP (R)','MASTER_AUTO_POSITION','MASTER_DELAY','MASTER_LOG_FILE','MASTER_PORT','MASTER_SSL','MASTER_SSL_CERT','MASTER_SSL_CRLPATH','MASTER_TLS_VERSION[m]','MAXVALUE (R)','MAX_ROWS','MAX_UPDATES_PER_HOUR','MEDIUMBLOB (R)','MEMORY','MICROSECOND','MINUTE','MIN_ROWS','MODIFIES (R)','MULTILINESTRING','MUTEX','NAMES','NCHAR','NEVER[o]','NO','NONE','NO_WRITE_TO_BINLOG (R)','NUMERIC (R)','OLD_PASSWORD[q]','ONLY','OPTIMIZER_COSTS[r] (R)','OPTIONS','OUT (R)','OWNER','PARSER','PARTITION (R)','PASSWORD','PLUGINS','POLYGON','PRECISION (R)','PREV','PROCEDURE (R)','PROFILES','QUARTER','RANGE (R)','READ_ONLY','REBUILD','REDO_BUFFER_SIZE','REGEXP (R)','RELAY_LOG_FILE','RELEASE (R)','RENAME (R)','REPEAT (R)','REPLICATE_DO_DB[u]','REPLICATE_IGNORE_TABLE[x]','REPLICATE_WILD_IGNORE_TABLE[aa]','RESET','RESTRICT (R)','RETURNED_SQLSTATE','REVOKE (R)','ROLLBACK','ROUTINE','ROW_COUNT','SAVEPOINT','SCHEMAS (R)','SECOND_MICROSECOND (R)','SENSITIVE (R)','SERIALIZABLE','SET (R)','SHUTDOWN','SIMPLE','SMALLINT (R)','SOME','SOURCE','SQL (R)','SQLWARNING (R)','SQL_BEFORE_GTIDS','SQL_CACHE','SQL_SMALL_RESULT (R)','SQL_TSI_HOUR','SQL_TSI_QUARTER','SQL_TSI_YEAR','START','STATS_AUTO_RECALC','STATUS','STORED[ac] (R)','SUBCLASS_ORIGIN','SUBPARTITIONS','SWAPS','TABLES','TABLE_NAME','TERMINATED (R)','THEN (R)','TIMESTAMPADD','TINYINT (R)','TRAILING (R)','TRIGGERS','TYPE','UNDEFINED','UNDO_BUFFER_SIZE','UNION (R)','UNLOCK (R)','UPDATE (R)','USE (R)','USE_FRM','UTC_TIME (R)','VALUE','VARCHAR (R)','VARYING (R)','WAIT','WEIGHT_STRING','WHILE (R)','WORK','X509','XML','YEAR_MONTH (R)'];
        if(inputv.length==0){tip.style.display="none";alert("请输入保留字！");return false}else{tip.style.display="block"}var reg=/^[A-Z]+$/;if(reg.test(inputv)==false){inputvs=inputv.toUpperCase()}else{inputvs=inputv}for(var t=0;t<arr.length;t++){if(arr[t]==inputvs){v="您输入的'"+inputv+"',是Mysql保留字。";break}}if(v.length>0){n=v;yet="√";tf="T"}else{n="您输入的'"+inputv+"',不是Mysql保留字。";yet="✕";tf="F"}tip.innerHTML="<a class='ta'>"+n+"</a><a id='yt' style='font-size: 32px'></a>";var yt=document.getElementById('yt');yt.innerHTML="<a>"+yet+"</a>";if(tf=="T"){yt.style.color="green"}else{yt.style.color="red"}
    }
</script>
</body>
</html>