How to concat datatypes like integers(integer with integer) & varchar(varchar with varchar) in mysql?

Question

How can we concat - integers with integers - varchar with varchar - int with varchar in MySQL ?

Accepted Answer

Use `CONCAT`

http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_concat

```
SELECT CONCAT(1, 2);
-- "12"

SELECT CONCAT('foo', 'bar');
-- "foobar"

SELECT CONCAT(1, 'bar');
-- "1bar"
```

Solution