log.sql for season 19 Part1-1

/* Navicat MySQL Data Transfer Source Server : MU Source Server Type : MySQL Source Server Version : 50743 (5.7.43-log) Source Host

常用SQL语<3>

插入new数据,检查是否已存在数据 DECLARE @newUsername NVARCHAR(255) = 'johway4'; -- 新账号名 DECLARE @newPassword NVARCHAR(255) = '123123'; -- 与新账号关联的密码 DECLARE @newM

常用SQL语句<2>

触发器查询 SELECT OBJECT_NAME(a.parent_obj) AS [表名] , a.name AS [触发器名称] , ( CASE WHEN b.is_disabled = 0 THEN '启用' ELSE '禁用

常用SQL语句<1>

封号/解封 update MEMB_INFO set bloc_code = 1 where memb___id='帐号' ===>>> 大于0 封号 =0 解封 创建账号 insert into dbo.MEMB_INFO(memb___id, memb__pwd,memb_name,sno