dbml icon indicating copy to clipboard operation
dbml copied to clipboard

[question] can i use mysql on update option?

Open necro42 opened this issue 4 years ago • 2 comments

I have used "DEFAULT current_timestamp() ON UPDATE current_timestamp()" as column default attribute.

but

default: `current_timestamp() ON UPDATE current_timestamp()`

is not to be used

can i use mysql table created on update option?

necro42 avatar Nov 23 '21 10:11 necro42

I need it too and its not working

idan3 avatar Feb 03 '22 16:02 idan3

ON UPDATE CURRENT_TIMESTAMP is exported from mysqldump and it doesn't correctly convert to DBML:

You have a syntax error at "test.sql" line 98 column 3. Expected ")" or fields but "d" found.

No, no I don't have a syntax error. It was exported from mysqldump. Please don't pretend to support MYSQL if you really don't.

seems this is also a duplicated of #141

ortonomy avatar Mar 02 '22 07:03 ortonomy