SET DEFAULT for MySQL

savvin's profile image savvin posted 3 months ago in Feature discussion Permalink

When creating foreign keys, it isn't possible to select SET DEFAULT in actions. Previously you added this for Postgres mode, is it possible to add it for MySQL?

ansgar's profile image ansgar posted 3 months ago Permalink

In much earlier versions there was no SET DEFAULT in MySQL. The documentation for MySQL 8.0 now says:

SET DEFAULT: This action is recognized by the MySQL parser, but both InnoDB and NDB reject table definitions containing ON DELETE SET DEFAULT or ON UPDATE SET DEFAULT clauses.

I'm not sure if it makes sense to support it through HeidiSQL, if MySQL then will reject it...?

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