连接函数concat:
select concat(‘id:’,id)id,concat(‘user:’,username)user,concat(‘password:’,password)pass from user;
2)
select id,username,password,concat(id,’-’,username,’-’,password) id user pass from user;
3)
select (id-1) as id,username,password from user;
随机数rand函数:
select * from user order by rand() limit 1;