首页 > 数据库 >MySQL保留字

MySQL保留字

时间:2022-09-01 21:45:55浏览次数:55  
标签:insert hour MySQL second 保留字 sql day minute

{"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"};

标签:insert,hour,MySQL,second,保留字,sql,day,minute
From: https://www.cnblogs.com/liuguiqing/p/16647910.html

相关文章

  • Mysql主从复制
    遇到的问题:#查看slave状态showslavestatus\G显示IO线程为连接:Slave_IO_Running:NO解决思路:1、检查changemasterto里用户名、密码、日志位置等信息;如果不行就......
  • 3.MySQL常用知识
    1,基础查询//1.groupby+聚合函数+HAVING条件过滤SELECTSEX,AVG(AGE)FROM`user`GROUPBYSEXHAVINGSEX='女'2,DCL语句1,创建用户,当前主机访问CREATEuser'ser......
  • Mysql (需5.6以上版本)Slave 延迟复制配置
    Mysql(需5.6以上版本)Slave延迟复制配置通过设置Slave上的MASTERTOMASTER_DELAY参数实现:CHANGEMASTERTOMASTER_DELAY=N;N为多少秒,该语句设置从数据库延时N秒后,再与......
  • MySQL Explain执行计划key_len详解(特意针对date和datetime详细测试说明)
    MySQLExplain执行计划key_len详解(特意针对date和datetime详细测试说明)我们在使用Explain查看SQL执行计划时,其中有一列为key_kenkey_len表示使用的索引长度,那么key_len......
  • MySQL5.7 datetime设置默认为当前时间
    DROPTABLEIFEXISTS`strategy`;CREATETABLE`strategy`(`id`bigint(11)NOTNULLAUTO_INCREMENTCOMMENT'自增ID',`create_time`datetime(3)DEFAULTCURR......
  • 连接MySQL出现Host is not allowed to connect to this MySQL server 解决方法
    前言关于这个问题在网上看过一些教程方法,因为本人是更倾向于细致化的比较看得懂,所以在操作的时候就一起记录一下操作步骤了提示:以下是本篇文章正文内容,下面案例可供参考......
  • MySql Host is blocked because of many connection errors; unblock with 'mysqladmi
     原因是:同一个ip在短时间内产生太多(超过mysql数据库max_connection_errors的最大值)中断的数据库连接而导致的阻塞 解决方法:/usr/bin/mysqladminflush-hosts-h172.......
  • MySQL常用日期函数
    目录1、日期函数1.1、CURDATE()1.2、CURRENT_DATE()1.3、CURRENT_DATE1.4、将日期转为19900101格式2、时间函数2.1、CURTIME()2.2、CURRENT_TIME()2.3、CURRENT_TIME3、日......
  • mysql 储存过程 如何使用递归循环来实现sql数据恢复
    CREATEPROCEDURE`relation_update`(inePIDvarchar(100),indeptidint)BEGINDECLAREtuivarchar(100);declarectint;declareiint;DECLAREcur1CURSORFORselect......
  • MYSQL数据库使用
    1.创建数据库createdatabase库名;2.确认数据库信息(所有的库名都显现)showdatabases; -->可查看是否创建成功了。3.指定或切换数据库  use数据库名4.显示当前使......