设置默认日期的MySQL语法 [英] MySQL Syntax for setting Default Date
问题描述
如何在mysql中将元素设置为某个默认日期?
How can we set element to some default date in mysql ?
-
在oracle中,我们会做一些类似
In oracle we would do something like
start_date DATE DEFAULT to_date('01011900','DDMMYYYY')
start_date DATE DEFAULT to__date('01011900','DDMMYYYY')
mutation_date_time DATE DEFAULT SYSDATE
mutation_date_time DATE DEFAULT SYSDATE
CONSTRAINT entity_specification UNIQUE(external_name, start_date_time,end_date_time))
CONSTRAINT entity_specification UNIQUE(external_name, start_date_time, end_date_time))
还有我们有任何网站或资源,我们可以获得MySQL等效的语法到Oracle语法。
Also do we have any site or resource where we can get MySQL equivalent syntax to Oracle Syntax.
更新
我试图按照回答中提到的做法,错误信息:
I tried to do as mentioned in answer but again am getting error message:
create table product_offer_type(object_id INT(19), snapshot_id INT(19), PRIMARY KEY(object_id,snapshot_id), enum_value VARCHAR(64) NOT NULL, external_name VARCHAR(64) NOT NULL, description VARCHAR(255), business_validation INT(1), valid_for_start_date_time DATE DEFAULT '1900-01-10', valid_for_end_date_timeDATE DEFAULT '4712-01-01', mutation_date_time DATE DEFAULT 'SYSDATE()', mutation_user VARCHAR(32) DEFAULT 'USER');
ERROR 1064 (42000): 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 'DEFAULT '4712-01-01', mutation_date_time DATE DEFAULT 'SYSDATE()', mutation_user' at line 1
mysql>
推荐答案
只需传递格式化的字符串。
Simply pass it a formatted string.
start_date DATE DEFAULT '1900-01-01'
这篇关于设置默认日期的MySQL语法的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!