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(); ...