SQL 一个语句不会写 求指点

更新员工Email，规则为：员工所在部门名称加员工姓名加“@lalala.com”,用一句SQL语句完成

用函数concat或者concat_ws:
update employee set email=concat(department,name,'@lalala.com');
update employee set email=concat_ws('',department,name,'@lalala.com');

参考自：
MySQL行转列、列转行常用函数用法介绍 http://www.data.5helpyou.com/article388.html

update employee set email=concat(Department,Name,"@lalala.com")

楼主才学Sql吧，你这样写
update employee set email=concat(department,name,'@lalala.com');
就对了

update employee set email=concat(department,name,'@lalala.com');

update employee set email=concat(department,name,'@lalala.com');