May 23, 2012

Post: AUTO_INCREMENT and MERGE TABLES

auto_increment value to be reused too. Can you use AUTO_INCREMENT clause in CREATE TABLE to get different auto_increment values ? I guess not: mysql> alter table am auto_increment=1000; Query

Post: Innodb row size limitation

AUTO_INCREMENTKEY (id) ) Engine=InnoDB; Now you insert some test data into it: mysql> INSERT INTO example -> VALUESmaximum allowed value. So, if your problem domain allows you to limit the size of