"double" or "DOUBLE"
From: Stefan Ram <ram_at_zedat.fu-berlin.de>
Date: 23 Aug 2015 16:02:09 GMT
Message-ID: <double-20150823165354_at_ram.dialup.fu-berlin.de>
In the MySQL manual types are written in upper case:
Date: 23 Aug 2015 16:02:09 GMT
Message-ID: <double-20150823165354_at_ram.dialup.fu-berlin.de>
In the MySQL manual types are written in upper case:
MySQL supports the SQL standard integer types INTEGER (or INT) The CHAR and VARCHAR types are similar
. When one uses »DESCRIBE« to get a description of a table, MySQL write types in lower case:
mysql> DESCRIBE City;
+------------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+----------+------+-----+---------+----------------+
| Id | int(11) | NO | PRI | NULL | auto_increment |
| Name | char(35) | NO | | | |
| Country | char(3) | NO | UNI | | |
| District | char(20) | YES | MUL | | |
| Population | int(11) | NO | | 0 | |
+------------+----------+------+-----+---------+----------------+
. Does this mean that the lower-case representation is more close to the metal of the actual implementation?
When one is writing about MySQL, should one use »INT« or »int«? Received on Sun Aug 23 2015 - 18:02:09 CEST