我现在我手上一个网站需要融合一个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;
我 对 视图不了解,希望有高手帮解说下……谢谢顺便有关于这个视图的代码也帮我解释下!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;
解决方案 »
- 求助,请问哪儿有最土团购的数据字典下载?
- 关于PHP小偷程序与CPU问题,请高手指导一下。。谢谢
- PHP正则表达式验证 撒分
- 怎么在一张朋友表里面查询和自己有相同朋友并且不是自己的朋友的用户
- 求高手帮忙我想写一个封装memcache类 并且把其他的get方法和set方法重写
- 招聘PHP人才+新年散分,顶的都有分!
- 写一本书关于php的书
- 在linux 下 pdflib 多语言问题
- ldap_search() [function.ldap-search]: Search: Operatio_n_s error [
- 构造函数析造函数
- xheditor开源编辑器ajax上传功能的完善(会C#的php高手进)
- 花钱请人做网站
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;返回的结果