hi_beijing的专栏

select [b]distinct[/b] .AreaID,a.AreaName,b.AreaID,b.AreaName,c.AreaID,c.AreaName from [b]表名 1[/b] as a , [b]表名1[/b] as b , [b]表名1[/b] as c , [b]表名2[/b] as pinpai where a.AreaID = big and b.AreaID ...

alter TABLE Asp_News with check add constraint foreignKey_News_UserID Foreign Key (UserID) References Asp_Members(ID) On Delete Cascade Not For Replication GO

 MySql分组查询语句： from Share as s left join fetch s.ruid Where s.ruid.ruid in(select f.friendRuid from Friends as f Where f.ruid.ruid=?) or s.ruid.ruid=? group by s.typeId,s.itemId order by count(s.conte...