我现在我手上一个网站需要融合一个SNS ，所以要把2个数据库中的用户注册表融合成一个，意思应该就是从数据库A中做个视图映射到数据库B吧。老板的意思应该就是从原来网站上的数据库中的注册表做个视图映射到 现在的 SNS 数据库中的一张表！！…………
我 对 视图不了解，希望有高手帮解说下……谢谢
顺便有关于这个视图的代码也帮我解释下！3Q
mysql> create view softinfo.softinfo_user2 as select
tu.id as id,
tu.email as account ,
tu.name as realname ,
tu.passwd as password,
tu.sex as sex,
mobile as mobile,
tu.email as email,
tu.current_province as province,
tu.current_city as city,
tu.address as address ,
tu.zipcode as zipcode,
tu.tel as tel,
tu.isadmin as isadmin,
cTime as regtime ,
ou.activeTime as lastlogin ,
tu.tmp as tmp ,
tu.isdong as isdong,
tu.dijiajun as dijiajun
from thinksns.ts_user as tu left join thinksns.ts_user_online as ou on tu.id = ou.uid;