MySQL Foreign Key Summary: in this tutorial, you will learn about MySQL foreign key and how to create, drop, and disable a foreign key constraint. Introduction to MySQL foreign key A foreign key is a column or group of columns in a table that links to a column or group of columns in another table.…
Read more
MySQL Primary Key Summary: in this tutorial, you will learn how to use MySQL primary key constraint to create the primary key for a table. Introduction to MySQL primary key A primary key is a column or a set of columns that uniquely identifies each row in the table. The primary key follows these rules:…
Read more
MySQL NOT NULL Constraint Summary: in this tutorial, you will learn how to define a NOT NULL constraint for a column, add a NOT NULL constraint to an existing column, and remove a NOT NULL constraint from a column. Introduction to the MySQL NOT NULL constraint The NOT NULL constraint is a column constraint that…
Read more
MySQL TRUNCATE Function Summary: in this tutorial, you will learn how to use the MySQL TRUNCATE() function to truncate a number to a specified number of decimal places. MySQL TRUNCATE() function truncates a number to a specified number of decimal places as shown below: TRUNCATE(X,D) Code language: SQL (Structured Query Language) (sql) In this syntax:…
Read more
MySQL ROUND Function Summary: in this tutorial, you will learn how to use the MySQL ROUND() function to round a number to a specified number of decimal places. Introduction to MySQL ROUND() function The ROUND() is a mathematical function that allows you to round a number to a specified number of decimal places. The following…
Read more
MySQL MOD Function Summary: in this tutorial, you will learn how to use the MySQL MOD() function to return the remainder of one number divided by another. MySQL MOD() function syntax The MOD() function returns the remainder of one number divided by another. The following shows the syntax of the MOD() function: MOD(dividend,divisor) Code language:…
Read more
MySQL FLOOR Function Summary: in this tutorial, you will learn how to use the MySQL FLOOR() function. The FLOOR() function accepts one argument which can be number or numeric expression and returns the largest integer number less than or equal to the argument. The following shows the syntax of the FLOOR() function: FLOOR(expression) Code language: SQL…
Read more
MySQL CEIL Function Summary: in this tutorial, you will learn about the MySQL CEIL() function. The CEIL() function takes an input number and returns the smallest integer greater than or equal to that number. The following shows the syntax of the CEIL() function: CEIL (numeric_expression) Code language: SQL (Structured Query Language) (sql) In this syntax,…
Read more
MySQL ABS Function Summary: in this tutorial, you will learn how to use the MySQL ABS() function to return the absolute value of a number. MySQL ABS() function overview The ABS() function is a mathematical function that returns the absolute (positive) value of a number. The following shows the syntax of the ABS() function: ABS(n)…
Read more
MySQL Math Functions This page covers all the MySQL Math functions with their descriptions for reference. Name Description ABS() Returns the absolute value of a number CEIL() Returns the smallest integer value greater than or equal to the input number (n). FLOOR() Returns the largest integer value not greater than the argument MOD() Returns the…
Read more