Seriously though it's like MySQL is actively trying to be bad.
Show this thread
Wait WTF MySQL implicitly inserts `CURRENT_TIMESTAMP` for `TIMESTAMP` columns by default?! And `foo TIMESTAMP DEFAULT NULL` is not valid in MySQL? WHAT THE ACTUAL FUCK?!pic.twitter.com/ulGqrw6S6B
-
-
-
This was completely moot anyway. You can't create a trigger in MySQL in a prepared statement because "this command is not supported yet". Awesome. Sorry MySQL Diesel users, you get to deal with `updated_at` yourselves.
Show this thread
End of conversation
New conversation -
-
-
I believe maybe only the first time stamp column on a table! I’ve told people about this before and they didn’t believe me and I couldn’t find corroborating documentation.
-
"stamp column on a table"? I joked when I was doing Diesel docs "maybe I should just leave the MySQL module undocumented. It's what they're used to"
- 1 more reply
New conversation -
-
-
"bar timestamp NULL" should work according to the docs: https://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html … - it seems a little overcomplicated
-
Doesn't make sense to have not null be default for this type but not others (and breaks the spec)
- 1 more reply
New conversation -
-
-
You should set variable sysvar_explicit_defaults_for_timestamp. See https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp …
-
Or use a DATETIME..
End of conversation
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.