不太明白 lz 的目的是什么 时间的话select now() from dual; 如果是时间戳格式就是 select unix_timestamp(now()) from dual;
不支持 The CHECK clause is parsed but ignored by all storage engines. http://dev.mysql.com/doc/refman/5.7/en/create-table.html用触发器做吧
不支持 The CHECK clause is parsed but ignored by all storage engines. http://dev.mysql.com/doc/refman/5.7/en/create-table.html用触发器做吧MariaDB [demo]> create or replace trigger trg_t_before before insert on t for each row -> begin -> if new.ts > now() then -> signal sqlstate '45000' set message_text = 'custom error'; -> end if; -> end; -> $$ Query OK, 0 rows affected (0.07 sec)MariaDB [demo]> insert into t (ts) values ('2016-12-12'); -> $$ ERROR 1644 (45000): custom error除了insert以外,还要有update的触发器
时间的话select now() from dual;
如果是时间戳格式就是
select unix_timestamp(now()) from dual;
不支持
The CHECK clause is parsed but ignored by all storage engines.
http://dev.mysql.com/doc/refman/5.7/en/create-table.html用触发器做吧
不支持
The CHECK clause is parsed but ignored by all storage engines.
http://dev.mysql.com/doc/refman/5.7/en/create-table.html用触发器做吧MariaDB [demo]> create or replace trigger trg_t_before before insert on t for each row
-> begin
-> if new.ts > now() then
-> signal sqlstate '45000' set message_text = 'custom error';
-> end if;
-> end;
-> $$
Query OK, 0 rows affected (0.07 sec)MariaDB [demo]> insert into t (ts) values ('2016-12-12');
-> $$
ERROR 1644 (45000): custom error除了insert以外,还要有update的触发器