As usual, MySQL is not nearly as elegant.
Show this thread
Fun fact: `VALUES` isn't syntax special to `INSERT` in PG and SQLite. It's just special syntax for a select statement. All INSERT statements are insert from select on those backends.pic.twitter.com/eQoWoeZJDs
-
-
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
Whoa! So it’s basically a literal tuple/relation of data!
-
Yup, it's basically sugar for `SELECT 1, 2 UNION ALL SELECT 2, 3`
End of conversation
New conversation -
-
-
This will blow your mind: https://www.cockroachlabs.com/docs/stable/selection-clauses.html …
-
Yup, that's how it works in SQLite and PG as well
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.