INSERT INTO Employee (Id, FirstName, LastName, Department, Salary, Gender, Age, City) VALUES (1005, 'Linda', 'Jones', 'HR', 75000, 'Female', 26, 'London') INSERT INTO Employee (Id, FirstName, LastName, Department, Salary, Gender, Age, City) VALUES (1004, 'Mike', 'Walker', 'Finance', 50000, 'Male', 28, 'London') INSERT INTO Employee (Id, FirstName, LastName, Department, Salary, Gender, Age, City) VALUES (1003, 'James', 'Brown', 'Finance', 50000, 'Male', 28, 'London') INSERT INTO Employee (Id, FirstName, LastName, Department, Salary, Gender, Age, City) VALUES (1002, 'Mary', 'Smith', 'HR', 45000, 'Female', 27, 'London') INSERT INTO Employee (Id, FirstName, LastName, Department, Salary, Gender, Age, City) VALUES (1001, 'John', 'Doe', 'IT', 35000, 'Male', 25, 'London') Please use the below SQL Script to create the Company database and the Employee table with the required data. We are going to use the below Employee table to understand Concatenation Operator. Let us understand the Concatenation Operator in MySQL with some examples using database table columns. SELECT CONCAT(‘MySQL’, ‘ ‘, ‘Tutorials’) Įxample of CONCAT Function using Null Argument If the argument is numeric, it is converted to its equivalent nonbinary string form.Įxample of MySQL CONCAT Function using One argumentĮxample of MySQL CONCAT Function using two argumentsĮxample of MySQL CONCAT Function using three arguments.The CONCAT function returns a binary string if the arguments include any binary strings.

The CONCAT function returns a nonbinary string if all arguments are nonbinary strings.It returns a single string as a result by concatenating all arguments.The CONCAT function may take one or more arguments.The CONCAT function can take n number of strings as arguments and return a single string as a result by adding all the input strings. CONCAT function syntax in MySQL:įollowing is the syntax to use the CONCAT function in MySQL. In MySQL, multiple strings are joined together using the CONCAT function. The concatenation operator joins two strings together. The Concatenation Operator in MySQL is the only operator which is used only for strings. Please read our previous article where we discussed Arithmetic Operators in MySQL with examples. In this article, I am going to discuss Concatenation and Temporal Operators in MySQL with Examples. Data Structures and Algorithms Tutorialsīack to: MySQL Tutorials for Beginners and Professionals Concatenation and Temporal Operators in MySQL.

Mysql concat function addresses