mysql> INSERT INTO t (a,b) VALUES ("1234", "5678"); Query OK, 1 row affected (0.00 sec) mysql> SELECT CONCAT(a,b) FROM t; +-------------+ | CONCAT(a,b) | +-------------+ | 12345678 | +-------------+