Type
숫자
- https://dev.mysql.com/doc/refman/8.0/en/numeric-types.html
- https://www.postgresql.org/docs/current/datatype-numeric.html
Type | Byte | MySQL | PostgreSQL |
---|---|---|---|
integer | 1 | tinyint | - |
integer | 2 | smallint | smallint |
integer | 3 | mediumint | - |
integer | 4 | int | integer |
integer | 8 | bigint | bigint |
float | 4 | float | real |
float | 8 | double | double precision |
float | numeric | numeric |
문자
Type | MySQL | PostgreSQL |
---|
날짜
Type | MySQL | PostgreSQL |
---|