13 ms·
Actually there isn't* a standard for auto increment columns. * There is one for an identity column, which often ends up being similar `GENERATED BY DEFAULT AS
by jimktrains2 9y ago
Actually there isn't* a standard for auto increment columns.
* There is one for an identity column, which often ends up being similar `GENERATED BY DEFAULT AS IDENTITY` https://blog.2ndquadrant.com/postgresql-10-identity-columns/ https://blog.2ndquadrant.com/postgresql-10-identity-columns/ https://dba.stackexchange.com/a/161356 https://dba.stackexchange.com/a/161356 and I don't believe mysql supports that syntax https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html https://dev.mysql.com/doc/refman/5.7/en/create-table-generat...