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.

Default Expressions - help

jagan007's profile image jagan007 posted 3 weeks ago in General Permalink

Hi All,

Im trying to add this default expression, but getting failed Expression : DATE_SUB(NOW(),INTERVAL 1 DAY)

Please find below the exisiting table structure Description

Trying to add a column with default expression -> DATE_SUB(NOW(),INTERVAL 1 DAY) Description

Am i doing any mistake or is it bug?

Thanks!

ansgar's profile image ansgar posted 3 weeks ago Permalink

Support for default expressions depend on the column type, and on the server version. I would look up what your server supports here in their online documentation.

jagan007's profile image jagan007 posted 3 weeks ago Permalink

My MYSQL version is 8.0.17

Any suggestion for me to achieve this?

Please login to leave a reply, or register at first.




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.