"SELECT uid,username,gender,"
+ "from_unixtime(regdate) as regdate,"
+ "from_unixtime(lastvisit) as lastvisit, "
+ "from_unixtime(lastpost) as laspost, "
+ "posts, digestposts, oltime, pageviews "
+ "from @catalog@.@prefix@members order by regdate desc limit ?,?";那个是搜索的members表
张乐华 13:19:03
catalog 和schema 是一样的
张乐华 13:19:41
是数据仓库 里面有很多数据库
+ "from_unixtime(regdate) as regdate,"
+ "from_unixtime(lastvisit) as lastvisit, "
+ "from_unixtime(lastpost) as laspost, "
+ "posts, digestposts, oltime, pageviews "
+ "from @catalog@.@prefix@members order by regdate desc limit ?,?";那个是搜索的members表
张乐华 13:19:03
catalog 和schema 是一样的
张乐华 13:19:41
是数据仓库 里面有很多数据库