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?
SET DEFAULT for MySQL
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.