MySQL supports all standard SQL integer types INTEGER or INT and SMALLINT. In addition, MySQL provides TINYINT MEDIUMINT, and BIGINT as extensions to the standard.
There are SQL standards: http://en.wikipedia.org/wiki/SQL#Standardization http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt However, most DBMSs still implement a somewhat custom or extended version of the standard. (Microsoft SQL Server being the prime suspect).
- modern-sql.com/standard
- Grammar (jakewheat.github.io/sql-overview)
- MariaDB Knowledge base (mariadb.com)
- SQL-92 draft (contrib.andrew.cmu.edu)
- MySQL / PostgreSQL Data_Types
- SQL Numeric Types:
- https://www.whoishostingthis.com/resources/ansi-sql-standards/
- https://aws.amazon.com/blogs/database/another-database-migration-playbook-goes-live-migrate-from-microsoft-sql-server-to-amazon-aurora-mysql/
- https://www.sqlstyle.guide/
- If simple then use validators and the standart.
- Else ORM.