qq_42418728的博客

salaries表:employees表：departments表：查询sql语句：use employee;DROP TABLE IF EXISTS tTable;DROP TABLE IF EXISTS max_salary;DROP TABLE IF EXISTS exclude_max_salary;CREATE TEMPORARY TABLE tTable AS( select * from salaries natural joi..

1.while循环delimiter //create table random_num (num int);drop procedure if exists ran1; create procedure ran1(num int) begin declare i int; set i = 0; while i<num do insert...