Re: MySQL function parameter types

From: Luuk <luuk_at_invalid.lan>
Date: Sat, 29 Aug 2015 19:22:49 +0200
Message-ID: <55e1ea6a$0$23857$e4fe514c_at_news.xs4all.nl>


On 29-08-15 17:48, Stefan Ram wrote:
> The MySQL manual contains function parameters. For example,
>
> FIND_IN_SET(str,strlist)
> FORMAT(X,D)
> HEX(N_or_S)
> COS(X)
> CRC32(expr)
> FORMAT(X,D)
> RAND(N)
>
> . Here, the parameters are:
>
> str
> strlst
> X
> D
> N_or_S
> expr
> N
>
> . I am looking for an explanation of the meanings of the
> parameter names.
>
> Some meanings can be guessed:
>
> X DOUBLE
> N INT
> str VARCHAR
>
> , but still an official explanation in the MySQL manual
> itself would be nice, yet I cannot find it!
>

It is explained per function.

if you look at FORMAT(X,D)
https://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_format

it says:
FORMAT(X,D) Formats the number X to a format like '#,###,###.##', rounded to D decimal places, and returns the result as a string. If D is 0, the result has no decimal point or fractional part.

what official explanation are you looking for, when just looking at this one function? Received on Sat Aug 29 2015 - 19:22:49 CEST

Original text of this message