创建视图
create view usersid as
select id from users
查看视图 show create view viewname
重新格式化检索的数据
select Concat(Rtrim(name),'(',RTeim(passwd).')')
as a from users
order by name
如果经常使用这些格式化的数据 则用视图
create view namepasswd as
select Concat(Rtrim(name),'(',RTeim(passwd).')')
as a from users
order by name