我有一个计数表,当重命名一个复合密钥字段时,我希望能够对计数进行求和。INSERT INTO test VALUES(2, 20, 3);INSERT INTO test VALUES(2, 30, 3);mysql> SELECT SUM(count) as count FROM test WHERE id = 2;| count || 9 |
my
当我做一个简单的修改时,它运行了将近10分钟: ADD `customer_ip2` VARCHAR(20) NOT NULL DEFAULT '' AFTER `comment`;但是当我把它的引擎改为MyISAM时,我得到的结果是:
mysql> alter table quote_followups_istvan