摘要:
--增加表cw_users的外键约束fk_users_group,表中的group_id受表cw_users_group中的主键id约束begin transactionalter table cw_users add constraint fk_users_groupforeign key (gr... 阅读全文
摘要:
select * from (select *,ROW_NUMBER() over (order by id) as rowNumfrom cw_diy_scene where category_id = @categoryId ) as tabwhere tab.rowNum between (@... 阅读全文