admin管理员组

文章数量:1612060

I need to create mysql table with default value on column CURRENT_DATE()

I try

DROP TABLE IF EXISTS `visitors`;

CREATE TABLE `visitors` (

`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,

`ip` VARCHAR(32) NOT NULL,

`browser` VARCHAR(500) NOT NULL,

`version` VARCHAR(500) NOT NULL,

`platform` ENUM('w','l','m') NOT NULL,

`date` TIMESTAMP NOT NULL DEFAULT CURRENT_DATE(),

PRIMARY KEY (`id`),

UNIQUE KEY `person` (`ip`,`date`)

) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

but it is writting an error

Query: CREATE TABLE `visitors` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `ip` VARCHAR(32) NOT NULL, `browser` VARCHAR(500) NO...

Error Code: 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 'CURRENT_DATE() NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `person` (`ip`,`date`)

) ENGINE=INNODB AUTO_INCREMENT=1' at line 7

Execution Time : 0 sec

Transfer Time : 0 sec

Total Time : 0.063 sec

what is the problem?

I need to uniques only date

not with full time info...

can you help me?

解决方案

Use CURRENT_TIMESTAMP function instead of CURRENT_DATE() function

Try this:

DROP TABLE IF EXISTS `visitors`;

CREATE TABLE `visitors` (

`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,

`ip` VARCHAR(32) NOT NULL,

`browser` VARCHAR(500) NOT NULL,

`version` VARCHAR(500) NOT NULL,

`platform` ENUM('w','l','m') NOT NULL,

`date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id`),

UNIQUE KEY `person` (`ip`,`date`)

) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

本文标签： 如何使用默认为时间currentdatemysql

版权声明：本文标题：currentdate mysql,如何使用列时间戳默认为current_date创建mysql表？ 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://www.elefans.com/xitong/1728627428a1166674.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。