docs/sql-manual/sql-functions/scalar-functions/string-functions/printf.md

{ “title”: “PRINTF”, “language”: “en”, “description”: “Returns a formatted string using the specified printf string and arguments.” }

Description

Returns a formatted string using the specified printf string and arguments.

:::tip This function is supported since version 3.0.6. :::

Syntax

PRINTF(<format>, [<args>, ...])

Parameters

Parameter	Description
`<format>`	The printf format string.
`<args>`	The arguments to be formatted.

Return Value

The formatted string using a printf mode.

Example

select printf("hello world");

+-----------------------+
| printf("hello world") |
+-----------------------+
| hello world           |
+-----------------------+

select printf('%d-%s-%.2f', 100, 'test', 3.14);

+-----------------------------------------+
| printf('%d-%s-%.2f', 100, 'test', 3.14) |
+-----------------------------------------+
| 100-test-3.14                           |
+-----------------------------------------+

select printf('Int: %d, Str: %s, Float: %.2f, Hex: %x', 255, 'test', 3.14159, 255);

+-----------------------------------------------------------------------------+
| printf('Int: %d, Str: %s, Float: %.2f, Hex: %x', 255, 'test', 3.14159, 255) |
+-----------------------------------------------------------------------------+
| Int: 255, Str: test, Float: 3.14, Hex: ff                                   |
+-----------------------------------------------------------------------------+