短信服务

招财猫短信服务


招财猫相关sql

<pre><code class="language-php">#岗位权限复制 #select * from mc_platform_roles where (NAME = &amp;#039;市场主管一考试院&amp;#039; OR NAME = &amp;#039;市场主管&amp;#039;) and pid = &amp;#039;fd98aedb14c44b87929eb1f454142d6d&amp;#039; #TMS角色权限复制 #select * from mc_employee_data_roles where data_role_name in (&amp;quot;全国二组考试院&amp;quot;,&amp;quot;全国一组考试院&amp;quot;,&amp;quot;北京高考一考试院&amp;quot;,&amp;quot;鲁粤皖高考一考试院&amp;quot;,&amp;quot;浙苏川高考一考试院&amp;quot;,&amp;quot;全国三组考试院&amp;quot;,&amp;quot;全国主管一考试院&amp;quot;,&amp;quot;学业规划一考试院&amp;quot;,&amp;quot;销售五组考试院&amp;quot;,&amp;quot;销售四组考试院&amp;quot;,&amp;quot;销售三组考试院&amp;quot;,&amp;quot;销售二组考试院&amp;quot;,&amp;quot;销售一组考试院&amp;quot;,&amp;quot;产品研培一考试院&amp;quot;,&amp;quot;运营一考试院&amp;quot;,&amp;quot;运营主管一考试院&amp;quot;,&amp;quot;总监一考试院&amp;quot;,&amp;quot;教务二组考试院&amp;quot;,&amp;quot;教务一组考试院&amp;quot;)</code></pre> <pre><code class="language-php">#登录相关 edubase.mc_members #用户表 edulogs.ec_login_logs #登录记录表 #岗位权限sql SELECT * FROM mc_members WHERE phone = 15100128182 OR phone = 13801279317 OR phone = 18500500393 SELECT * FROM mc_employees WHERE member_id = &amp;#039;1164e8a079034f4c974d069050223512&amp;#039; OR member_id = &amp;#039;35dde52f12cc4014b9f69eb24546598f&amp;#039; OR member_id = &amp;#039;fefe80b91f544f5180224cd61199afc3&amp;#039;; SELECT * FROM mc_employee_role #数据权限表 gc_campus #校区表,数据权限中,校区id mc_employee_data_roles #数据角色表 mc_merchant_departments #部门表 gc_grades #年部年级表 mc_classification_ands #渠道表 </code></pre> <pre><code class="language-php">#将密码重置为 123456Zcmiax 9b7db979270081a8edeff037febe2b6e UPDATE edubase.mc_members SET PASSWORD = &amp;#039;9b7db979270081a8edeff037febe2b6e&amp;#039; WHERE phone = &amp;#039;1850037****&amp;#039;; #去除登录记录 DELETE FROM edulogs.ec_login_logs WHERE id IN ( SELECT id FROM ( SELECT id FROM edulogs.ec_login_logs WHERE member_id IN ( SELECT id FROM edubase.mc_members WHERE phone = &amp;#039;1850037****&amp;#039; ) ORDER BY created DESC LIMIT 3 ) AS subquery );</code></pre>

页面列表

ITEM_HTML