what is

Signed vs Unsigned Integers

by

The integer data type is probably one of the more common data types when working with database management systems (and with computing in general). The integer is a numeric data type that allows us to store certain kinds of numbers.

More specifically, an integer is the number zero (0), a positive natural number (e.g. 1, 2, 3, …) or a negative integer with a minus sign (e.g. −1, −2, −3, …). Integers contain no decimal or fractional part.

However, many computing environments distinguish between signed integers and unsigned integers.

Let’s take a look at the difference between signed integers and unsigned integers.

Read more

FORMAT_BYTES() in MySQL

by

In MySQL, FORMAT_BYTES() is a built in function that converts a numeric byte count to a more human-readable format. It returns a string consisting of the value and a units indicator.

We provide the numeric byte count when we call the function.

Read more

SQLite ABS() Explained

by

In SQLite, ABS() is a built-in scalar function that returns the absolute value of its argument.

The absolute value is the non-negative equivalent of the argument. It can be thought of as the distance from zero that the number resides on the number line, without considering direction.

Read more

MySQL VERSION() Explained

by

In MySQL, VERSION() is a built-in function that returns the MySQL server version.

The result is a string that uses the utf8mb3 character set. A suffix may also be appended to the version number indicating server build or configuration information.

Read more

MySQL USER() Explained

by

In MySQL, USER() is a built-in function that returns the current MySQL user name and host name, given when connecting to MySQL.

The result is returned as a string in the utf8mb3 character set.

The value returned by USER() could be different to the value returned by CURRENT_USER().

Read more