Re: "double" or "DOUBLE"

From: The Natural Philosopher <tnp_at_invalid.invalid>
Date: Sun, 23 Aug 2015 17:09:14 +0100
Message-ID: <mrcr7a$lqj$1_at_news.albasani.net>


On 23/08/15 17:02, Stefan Ram wrote:
> 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«?
>
AFAIK SQL doesn't give a rats ass about case in keywords

The 'metal' will be machine code.

-- 
New Socialism consists essentially in being seen to have your heart in 
the right place whilst your head is in the clouds and your hand is in 
someone else's pocket.
Received on Sun Aug 23 2015 - 18:09:14 CEST

Original text of this message