Shulou(Shulou.com)06/01 Report--

Achieve simple table movement and use cursor loops

The first line DELIMITER / / and the last line / / must, otherwise an error will be reported if you encounter a semicolon

DELIMITER / / create procedure movedata () BEGIN DECLARE Done INT DEFAULT 0; DECLARE v_id VARCHAR (30); / * declare cursors * / DECLARE rs CURSOR FOR SELECT id FROM `new`.customer; / * exception handling * / DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' customer = 1; / * Open cursors * / OPEN rs / * to extract the value of the LingQi field of the current record one by one, you need to determine the maximum value * / FETCH rs INTO vroomid; / * traverse the data table * / REPEAT IF NOT Done THEN insert into `old`.customer (id,idcard_no) (select id+100000,idcard_no from `new`.customer where id = v_id); END IF FETCH rs INTO vault; UNTIL Done END REPEAT; / * close cursors * / CLOSE rs; END / /

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.