原表demo1:
现希望将last_name和first_name两列合并形成新列name,并在name中间有空格
select id,concat(last_name,' ','first_name') as name
from demo1;
现希望将last_name和first_name两列合并形成新列name
select id,concat(last_name,first_name') as name
from demo1;
原表demo1:
现希望将last_name和first_name两列合并形成新列name,并在name中间有空格
select id,concat(last_name,' ','first_name') as name
from demo1;
现希望将last_name和first_name两列合并形成新列name
select id,concat(last_name,first_name') as name
from demo1;