Giter VIP home page Giter VIP logo

执行schema.sql中的sql语句报错:[HY000][1293] Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause about everyone-java-blog HOT 7 CLOSED

xiaolongzuo avatar xiaolongzuo commented on July 17, 2024
执行schema.sql中的sql语句报错:[HY000][1293] Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

from everyone-java-blog.

Comments (7)

NoGameNoLife00 avatar NoGameNoLife00 commented on July 17, 2024

网上查到的原因是:给一个timestamp设置为on update current_timestamp的时候,其他的timestamp字段需要显式设定default值,但是一个表中有两个timestamp字段的时候,需要把第一个字段设置为current_timestamp,第二个字段不设置默认值才能成功创建表

CREATE TABLE `java_blog`.`blog_config` (
  `id` INT NOT NULL AUTO_INCREMENT COMMENT '主键',
  `update_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_time` TIMESTAMP NOT NULL COMMENT '创建时间',
  `web_user_id` INT NOT NULL COMMENT '用户ID',
  `introduction` VARCHAR(200) NOT NULL DEFAULT '' COMMENT '用户简介',
  `address` VARCHAR(100) NOT NULL COMMENT '用户博客地址',
  PRIMARY KEY (`id`)
)  ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='WEB端用户博客配置表';

也就是要改成这样才能成功创建表:

还有其他什么解决方法吗?

from everyone-java-blog.

xiaolongzuo avatar xiaolongzuo commented on July 17, 2024

怎么感觉你说的有点自相矛盾。。。。

from everyone-java-blog.

NoGameNoLife00 avatar NoGameNoLife00 commented on July 17, 2024

@xiaolongzuo 这个是网上的解释,链接:http://www.cnblogs.com/yoyo24456/p/3632462.html
其实我就是想单纯问下为什么直接执行schema.sql文件会报这个错误。。

from everyone-java-blog.

xiaolongzuo avatar xiaolongzuo commented on July 17, 2024

这个按说不会的。你是mysql吗。

from everyone-java-blog.

xiaolongzuo avatar xiaolongzuo commented on July 17, 2024

还有就是你的版本是多少。

from everyone-java-blog.

NoGameNoLife00 avatar NoGameNoLife00 commented on July 17, 2024

@xiaolongzuo mysql 5.0

from everyone-java-blog.

NoGameNoLife00 avatar NoGameNoLife00 commented on July 17, 2024

@xiaolongzuo 我试了下另外一台机子mysql 5.6上去执行,可以成功。应该是版本问题5.0不支持这个语法吧

from everyone-java-blog.

Related Issues (6)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.