xuSir_1的博客

—创建索引管理表 DROP TABLE IF EXISTS sequence; CREATE TABLE sequence ( name VARCHAR(50) NOT NULL, current_value INT NOT NULL, increment INT NOT NULL DEFAULT 1, PRIMARY KEY (name

-- 删除存储过程 drop PROCEDURE event_insert -- 创建存储过程 create PROCEDURE event_insert()  begin  INSERT into settlement(date,num)  select create_time,id from car_info ; end ; -- 调用存储过程 call event_insert();   ...