56,912
社区成员




CREATE TABLE tbalseAll (
id int(11) NOT NULL auto_increment,
tablename varchar(50) default NULL,
PRIMARY KEY (id)
);
INSERT INTO tbalseAll VALUES ('1', 'tb1');
INSERT INTO tbalseAll VALUES ('2', 'tb2');
INSERT INTO tbalseAll VALUES ('3', 'tb3');
CREATE TABLE tb1 (
aaaa int default NULL
);
CREATE TABLE tb2 (
aaaa int default NULL
);
CREATE TABLE tb3 (
aaaa int default NULL
);
INSERT INTO tb1 VALUES (4);
INSERT INTO tb1 VALUES (5);
INSERT INTO tb2 VALUES (3);
INSERT INTO tb2 VALUES (3);
INSERT INTO tb3 VALUES (9);
SELECT CONCAT('UPDATE ',GROUP_CONCAT(tablename), ' SET ',
GROUP_CONCAT(CONCAT(tablename, '.aaaa=', tablename,'.aaaa+1')))
INTO @sql
FROM tbalseAll;
PREPARE st FROM @sql;
EXECUTE st;
DEALLOCATE PREPARE st;
SELECT * FROM tb1;
SELECT * FROM tb2;
SELECT * FROM tb3;