In MySQL, the CHAR() function returns the character for each integer passed. In other words, you can pass in one or more integers, and the function will interpret those as code values for string characters and return the corresponding string for each code value.
Category: DBMS
Database Management Systems
How the EXPORT_SET() Function Works in MySQL
The MySQL EXPORT_SET() function returns a string that represents the bits in a number.
You have the ability to customise how the function outputs the string. The function accepts a number of arguments that allows you to do this. When you call the function, you provide the number in question, as well as arguments that determine how the results are displayed.
MySQL Mathematical Functions (Full List)
MySQL includes a bunch of functions and operators that can help us when working with data.
The following is a list of mathematical functions available in MySQL. You can click on each function name to see an explanation of the function, its syntax, and examples.
SQL Server Mathematical Functions (Full List)
Transact-SQL contains a number of mathematical functions that you can use with SQL Server.
The following scalar functions can be used in SQL Server 2012 and above. Most of these functions accept one or more arguments, and will return a numeric value based on the argument/s supplied.
TAN() Examples in SQL Server
In SQL Server, the TAN() function returns the tangent of the input expression.
You provide the value as an argument when calling the function.
SQUARE() Examples in SQL Server
Using SQL Server, you can use the T-SQL SQUARE() function to return the square of a specified float value. The square of a number is the result of multiplying the number by itself.
You provide the number as an argument when calling the function.
The return data type is float.
SQRT() Examples in SQL Server
Using SQL Server, you can use the T-SQL SQRT() function to return the square root of a specified float value.
You provide the number as an argument when calling the function.
The return data type is float.
SIN() Examples in SQL Server
Using SQL Server, you can use the T-SQL SIN() function to return the sine of a number. More specifically, this function returns the trigonometric sine of the specified angle, in radians, and in an approximate numeric, float, expression.
The return data type is float.
You provide the number as an argument when calling the function.
SIGN() Examples in SQL Server
In SQL Server, the T-SQL SIGN() function returns the sign of a number. In other words, it indicates whether or not the value is a positive number, a negative number, or zero.
You provide the number as an argument when calling the function.
The function returns the following result, depending on whether the argument is positive, negative, or zero.
- 1 if the number is positive
- -1 if the number is negative
- 0 if the number is zero
ROUND() Examples in SQL Server
In SQL Server, the T-SQL ROUND() function allows you to round a number to a specified length or precision.
You provide the number as an argument, as well as the length you’d like the number to be rounded to. The function also accepts an optional third argument that allows you to specify whether the number is rounded or truncated.