Page tree
Skip to end of metadata
Go to start of metadata

1.描述

数据库的保留关键字是具有重要意义的词,在创建数据库名称(DBName)时,请避免使用保留关键词

2.MySQL数据库保留关键词

云数据库类型

保留关键词

MySQL

accessible,account,action,actual,add,after,against,aggregate,all,algorithm,alter,always,analyse,analyze,and,any,as,asc,ascii,asensitive,at,auto_increment,autoextend_size,avg,avg_row_length,backup,before,begin,between,bigint,binary,binlog,bit,blob,block,bool,boolean,both,btree,by,byte,cache,call,cascade,cascaded,case,catalog_name,chain,change,changed,channel,char,character,charset,check,checksum,cipher,class_origin,client,close,coalesce,code,collate,collation,column,column_format,column_name,columns,comment,commit,committed,compact,completion,compression,compressed,encryption,concurrent,condition,connection,consistent,constraint,constraint_catalog,constraint_name,constraint_schema,contains,context,continue,convert,cpu,create,cross,cube,current,current_date,current_time,current_timestamp,current_user,cursor,cursor_name,data,database,databases,datafile,date,datetime,day,day_hour,day_microsecond,day_minute,day_second,deallocate,dec,decimal,declare,default,default_auth,definer,delayed,delay_key_write,desc,describe,des_key_file,deterministic,diagnostics,directory,disable,discard,disk,distinct,distinctrow,div,do,double,drop,dual,dumpfile,duplicate,dynamic,each,else,elseif,enable,enclosed,end,ends,engine,engines,enum,error,errors,escape,escaped,event,events,every,exchange,execute,exists,exit,expansion,export,expire,explain,extended,extent_size,false,fast,faults,fetch,fields,file,file_block_size,filter,first,fixed,float,float4,float8,flush,follows,for,force,foreign,format,found,from,full,fulltext,function,general,group_replication,geometry,geometrycollection,get_format,get,generated,global,grant,grants,group,handler,hash,having,help,high_priority,host,hosts,hour,hour_microsecond,hour_minute,hour_second,identified,if,ignore,ignore_server_ids,import,in,index,indexes,infile,initial_size,inner,inout,insensitive,insert_method,install,instance,int,int1,int2,int3,int4,int8,integer,interval,into,io,io_after_gtids,io_before_gtids,io_thread,ipc,is,isolation,issuer,iterate,invoker,join,json,key,keys,key_block_size,kill,language,last,leading,leave,leaves,left,less,level,like,limit,linear,lines,linestring,list,load,local,localtime,localtimestamp,lock,locks,logfile,logs,long,longblob,longtext,loop,low_priority,master,master_auto_position,master_bind,master_connect_retry,master_delay,master_host,master_log_file,master_log_pos,master_password,master_port,master_retry_count,master_server_id,master_ssl,master_ssl_ca,master_ssl_capath,master_tls_version,master_ssl_cert,master_ssl_cipher,master_ssl_crl,master_ssl_crlpath,master_ssl_key,master_ssl_verify_server_cert,master_user,master_heartbeat_period,match,max_connections_per_hour,max_queries_per_hour,max_rows,max_size,max_updates_per_hour,max_user_connections,maxvalue,medium,mediumblob,mediumint,mediumtext,memory,merge,message_text,microsecond,middleint,migrate,minute,minute_microsecond,minute_second,min_rows,mod,mode,modifies,modify,month,multilinestring,multipoint,multipolygon,mutex,mysql_errno,name,names,national,natural,ndb,ndbcluster,nchar,never,new,next,no,no_wait,nodegroup,none,not,no_write_to_binlog,null,number,numeric,nvarchar,offset,on,one,only,open,optimize,optimizer_costs,options,option,optionally,or,order,out,outer,outfile,owner,pack_keys,parser,page,parse_gcol_expr,partial,partition,partitioning,partitions,password,phase,plugin,plugins,plugin_dir,point,polygon,port,precedes,precision,prepare,preserve,prev,primary,privileges,procedure,process,processlist,profile,profiles,proxy,purge,quarter,query,quick,range,rds_charsetnum,rds_connection_id,rds_prepare_begin_id,rds_current_connection,rds_db,rds_rw_mode,rds_host_show,rds_resetconnection,read,read_only,read_write,reads,real,rebuild,recover,redo_buffer_size,redofile,redundant,references,regexp,relay,relaylog,relay_log_file,relay_log_pos,relay_thread,release,reload,remove,rename,reorganize,repair,repeatable,replication,replicate_do_db,replicate_ignore_db,replicate_do_table,replicate_ignore_table,replicate_wild_do_table,replicate_wild_ignore_table,replicate_rewrite_db,repeat,require,reset,resignal,restore,restrict,resume,returned_sqlstate,return,returns,reverse,revoke,right,rlike,rollback,rollup,routine,rotate,row,row_count,rows,row_format,rtree,savepoint,schedule,schema,schema_name,schemas,second,second_microsecond,security,sensitive,separator,serial,serializable,session,server,set,share,show,shutdown,signal,signed,simple,slave,slow,snapshot,smallint,socket,some,soname,sounds,source,spatial,specific,sql,sqlexception,sqlstate,sqlwarning,sql_after_gtids,sql_after_mts_gaps,sql_before_gtids,sql_big_result,sql_buffer_result,sql_cache,sql_calc_found_rows,sql_filters,sql_no_cache,sql_small_result,sql_thread,sql_tsi_second,sql_tsi_minute,sql_tsi_hour,sql_tsi_day,sql_tsi_week,sql_tsi_month,sql_tsi_quarter,sql_tsi_year,ssl,stacked,start,starting,starts,stats_auto_recalc,stats_persistent,stats_sample_pages,status,stop,storage,stored,straight_join,string,subclass_origin,subject,subpartition,subpartitions,super,suspend,swaps,switches,table,table_name,tables,tablespace,table_checksum,temporary,temptable,terminated,text,than,then,time,timestamp,timestampadd,timestampdiff,tinyblob,tinyint,tinytext,to,trailing,transaction,trigger,triggers,true,truncate,type,types,uncommitted,undefined,undo_buffer_size,undofile,undo,unicode,union,unique,unknown,unlock,uninstall,unsigned,until,upgrade,usage,use,user,user_resources,use_frm,using,utc_date,utc_time,utc_timestamp,validation,value,values,varbinary,varchar,varcharacter,variables,varying,wait,warnings,week,weight_string,when,where,while,view,virtual,with,without,work,wrapper,write,x509,xor,xa,xid,xml,year,year_month,zerofill,lag,rds_audit,rds_inner_backup,rds_change_user,rds_user,rds_ip,rds_add_proxy_protocol_networks,rds_show_proxy_protocol_ips,sync,delete,insert,replace,select,update,adddate,bit_and,bit_or,bit_xor,cast,count,curdate,curtime,date_add,date_sub,extract,group_concat,json_objectagg,json_arrayagg,max,mid,min,now,position,session_user,std,stddev,stddev_pop,stddev_samp,subdate,substr,substring,sum,sysdate,system_user,test,trim,variance,var_pop,var_samp,bka,bnl,dupsweedout,firstmatch,intoexists,loosescan,materialization,max_execution_time,no_bka,no_bnl,no_icp,no_mrr,no_range_optimization,no_semijoin,mrr,qb_name,semijoin,subquery

3.SQL Server数据库保留关键词

云数据库类型

保留关键词

SQL Server

root, admin, eagleye, master, aurora, sa, sysadmin, administrator, mssqld, public, securityadmin, serveradmin, setupadmin, processadmin, diskadmin, dbcreator, bulkadmin, tempdb, msdb, model, distribution, mssqlsystemresource, guest, add, except, percent, all, exec, plan, alter, execute, precision, and, exists, primary, any, exit, print, as, fetch, proc, asc, file, procedure, authorization, fillfactor, public, backup, for, raiserror, begin, foreign, read, between, freetext, readtext, break, freetexttable, reconfigure, browse, from, references, bulk, full, replication, by, function, restore, cascade, goto, restrict, case, grant, return, check, group, revoke, checkpoint, having, right, close, holdlock, rollback, clustered, identity, rowcount, coalesce, identity_insert, rowguidcol, collate, identitycol, rule, column, if, save, commit, in, schema, compute, index, select, constraint, inner, session_user, contains, insert, set, containstable, intersect, setuser, continue, into, shutdown, convert, is, some, create, join, statistics, cross, key, system_user, current, kill, table, current_date, left, textsize, current_time, like, then, current_timestamp, lineno, to, current_user, load, top, cursor, national, tran, database, nocheck, transaction, dbcc, nonclustered, test, trigger, deallocate, not, truncate, declare, null, tsequal, default, nullif, union, delete, of, unique, deny, off, update, desc, offsets, updatetext, disk, on, use, distinct, open, user, distributed, opendatasource, values, double, openquery, varying, drop, openrowset, view, dummy, openxml, waitfor, dump, option, when, else, or, where, end, order, while, errlvl, outer, with, escape, over, writetext, galaxy


回到顶部

  • No labels