我现在我手上一个网站需要融合一个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;其中softinfo为数据库一,softinfo_user为该数据库中的一表名。该数据库中所有表明的前缀都为softinfo
其中hinksns为数据库一,ts_user_online为该数据库中的一表名。该数据库中所有表明的前缀都为ts
我 对 视图不了解,希望有高手帮解说下……谢谢 顺便有关于这个视图的代码也帮我解释下!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;其中softinfo为数据库一,softinfo_user为该数据库中的一表名。该数据库中所有表明的前缀都为softinfo
其中hinksns为数据库一,ts_user_online为该数据库中的一表名。该数据库中所有表明的前缀都为ts
from thinksns.ts_user ---表1
as tu --别名
left join --左连接(结果包含白表1所有记录)
thinksns.ts_user_online ---表2
as ou
on ---通过下面的条件连接
tu.id = ou.uid
了解一点了,我去吃饭了了研究!
另外问下4楼的
js_szy
(尤迪安)
你是 WOW的?