锌镉熔融

题解

/ 注册

全部文章 / 题解（共2篇）

SQL48

update salaries set salary = salary * 1.1 where salaries.to_date='9999-01-01' and emp_no in (select emp_no from emp_bonus)

2020-10-13

0 554

SQL41 构造一个触发器audit_log

答案 create trigger audit_log after insert on employees_test for each row begin insert into audit values(new.id,new.name); end在MySQL中，创建触发器语法如下： ...

2020-10-13

211 2906