Re: Treat ON UPDATE CURRENT_TIMESTAMP as generated column?

2021-11-13 Thread Ben Schmeckpeper
That is a good point. The timestamp defaults to the current time if a value is not given for the column during an UPDATE, but if a value is given for the column, that is used instead. (A MySQL console session showing this is below.) I can work on a PR to include an :extra key in the schema

Re: Treat ON UPDATE CURRENT_TIMESTAMP as generated column?

2021-11-13 Thread Jeremy Evans
On Sat, Nov 13, 2021 at 6:53 AM Ben Schmeckpeper wrote: > Good morning. > > When querying a MySQL table's schema, I would like to know if a column has > ON UPDATE CURRENT_TIMESTAMP set. > > I found an earlier question where it was explained that MySQL's usage of > that syntax is non-standard and

Treat ON UPDATE CURRENT_TIMESTAMP as generated column?

2021-11-13 Thread Ben Schmeckpeper
Good morning. When querying a MySQL table's schema, I would like to know if a column has ON UPDATE CURRENT_TIMESTAMP set. I found an earlier question where it was explained that MySQL's usage of that syntax is non-standard and not supported for table creation, which I understand. Would it be