mysql 拼接字符函数 concat
mysql 的concat函数可以实现数据库中字段的自由拼接 并且保存成临时字段
/
mysql> select id,username,concat( id, '-' , username) as truename from pri_admins; +----+----------+----------+ | id | username | truename | +----+----------+----------+ | 1 | admin | 1-admin | | 3 | lanzhe | 3-lanzhe | | 4 | erin | 4-erin | | 5 | zlw | 5-zlw | | 6 | gjy | 6-gjy | +----+----------+----------+ 5 rows in set (0.00 sec)