Invalid default value for type DATE '0000-00-00'
Ads were blocked - no problem. But keep in mind that developing HeidiSQL,
user support and hosting takes time and money. You may want to
send a donation instead.
Invalid default value for type DATE '0000-00-00'
adyoi posted
11 months ago
10.3.16-MariaDB
adyoi posted
11 months ago
invalid default value
DATE DATETIME TIMESTAMP
Ads were blocked - no problem. But keep in mind that developing HeidiSQL,
user support and hosting takes time and money. You may want to
send a donation instead.
ansgar posted
11 months ago
Please write in whole sentences, and describe what you were doing.
adyoi posted
11 months ago
Please write in whole sentences, and describe what you were doing.
create new table and update table with default value '0000-00-00'
adyoi posted
11 months ago
screenshot
1 attachment(s):
ansgar posted
11 months ago
Not sure why the server rejects that change. I just could successfully do the same on MariaDB 10.3.12:
ALTER TABLE `test`
CHANGE COLUMN `d` `d` DATE NOT NULL DEFAULT '0000-00-00' AFTER `Mt`;'0000-00-00' is not allowed in TRADITIONAL/NO_ZERO_DATE SQL mode. Perhaps you have activated that.
adyoi posted
11 months ago
Not sure why the server rejects that change. I just could successfully do the same on MariaDB 10.3.12:
ALTER TABLE `test` CHANGE COLUMN `d` `d` DATE NOT NULL DEFAULT '0000-00-00' AFTER `Mt`;'0000-00-00' is not allowed in TRADITIONAL/NO_ZERO_DATE SQL mode. Perhaps you have activated that.
fix with sql mode
SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION'; SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION';
Please login to leave a reply, or register at first.
