mysql单表多timestamp报错#1293 - Incorrect table definition; there can be only one TIMESTAMP column with C
来源:互联网 发布:php授权验证系统2.7.0 编辑:程序博客网 时间:2024/05/16 15:04
一个表中出现多个timestamp并设置其中一个为current_timestamp的时候经常会遇到
#1293 - Incorrect table definition; there can be only oneTIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATEclause
原因是当你给一个timestamp设置为on updatecurrent_timestamp的时候,其他的timestamp字段需要显式设定default值
#1293 - Incorrect table definition; there can be only oneTIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATEclause
原因是当你给一个timestamp设置为on updatecurrent_timestamp的时候,其他的timestamp字段需要显式设定default值
但是如果你有两个timestamp字段,但是只把第一个设定为current_timestamp而第二个没有设定默认值,mysql也能成功建表,但是反过来就不行...
N.B:红色的解释是网上的,实际上on updatecurrent_timestamp(在navicat中文版中为“刷新当前时间戳计时”选项)只能设置一个,或者不设置都可以,不能同时设置2个及以上。
- mysql单表多timestamp报错#1293 - Incorrect table definition; there can be only one TIMESTAMP column with C
- Mysql 1293 - Incorrect table definition; there can be only one TIMESTAMP column with C
- [Err] 1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTA
- error : Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in
- mysql报ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must
- MySQL 5.4.6之前有关timestamp设置current_timestamp时报错there can be only one TIMESTAMP column with CURRENT_TI
- 创建主键时报错:ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it mus
- 创建主键时报错:ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it mus
- there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
- there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
- there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT
- [Err] 1075 - Incorrect table definition; there can be only one auto column and it must be defined as
- 1075 - Incorrect table definition;there can be only one auto column and it must be defined as a key
- Incorrect table definition; there can be only one auto column and it must be defined as a key
- [Err] 1075 - Incorrect table definition; there can be only one auto column and it must be defined as
- 1075-Incorrect table definition;there can be only one auto column and it must be defined as a key
- ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be def
- ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be def
- 第三届蓝桥杯复赛题解析
- Away3d 三维物体的操控
- 幸运28的单双投注技巧
- 汉字区位码
- 命令行的乱码以及编码的问题的解决方法
- mysql单表多timestamp报错#1293 - Incorrect table definition; there can be only one TIMESTAMP column with C
- 第三届蓝桥杯复赛原题
- DedeCMS默认作者和默认来源修改 SQL批量修改来源和作者
- Fedora 18 U盘安装方法
- pcie的hotplug概念
- 简单的DNS请求报文实现
- Java处理Office平台总结
- Away3D基础技巧
- 几种截屏的办法