摘要:
-- 查找树的所有子节点 with cte as (select Id,Pid,Name from dc_trees where pid=2union allselect t.id,t.pid,t.Name from cte a,dc_trees t where t.pid=a.id)select 阅读全文
摘要:
JS正则表达式验证账号、手机号、电话和邮箱效果体验:http://keleyi.com/keleyi/phtml/jstexiao/15.htm验证帐号是否合法验证规则:字母、数字、下划线组成,字母开头,4-16位。function checkUser(str){ var re = /^[a-... 阅读全文
摘要:
1 删除整张表的数据,并还原自增长值TRUNCATE TABLE TbWeixinActivity 2 3张表左连接select a.ID,c.Name,b.nickname,a.CreateDate from TbUserJoin as a left join tbWX_User as b o... 阅读全文