Mysql5.5 [Err] 1064 timestamp(14)

最新推荐文章于 2023-03-21 14:53:04 发布

原创最新推荐文章于 2023-03-21 14:53:04 发布 · 2.8k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #null #structure #table #server #sql

mysql 专栏收录该内容

6 篇文章

订阅专栏

本文详细解释了在MySQL中使用timestamp(14)时遇到的错误，并提供了修复解决方案。通过将timestamp(14)更改为timestamp，可以解决语法错误并顺利完成表格创建。

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL DEFAULT 'NOW()',
  reciptype enum('bcc','cc','to') default NULL,
 ' at line 9

[Err] --
-- Table structure for table `edgemap`
--

CREATE TABLE edgemap (
  senderid int(10) unsigned default NULL,
  recipientid int(10) unsigned default NULL,
  messageid int(10) unsigned default NULL,
  messagedt timestamp(14) NOT NULL DEFAULT 'NOW()',
  reciptype enum('bcc','cc','to') default NULL,
  subject varchar(255) default NULL,
  KEY senderid (senderid,recipientid),
  KEY messageid (messageid),
  KEY messagedt (messagedt),
  KEY senderid_2 (senderid),
  KEY recipientid (recipientid)
) ENGINE=MyISAM;

[Msg] Finished - Unsuccessfully

--------------------------------------------------

https://bugs.oxid-esales.com/view.php?id=2567

http://zhidao.baidu.com/question/293027668.html?fr=qrl&cid=871&index=2

原因：

Mysql5.5：timestamp(14)" does not work anymore.This can be resolved by changing all occurrences of "timestamp(14)" to "timestamp" in database.sql.