chapagain

chapagain

# Get the auto_increment value of all the tables of a database
SELECT `AUTO_INCREMENT`,`TABLE_NAME` FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA ='magento' ORDER BY AUTO_INCREMENT asc;

# Alternative way to check the auto_increment value of a table
SHOW TABLE STATUS FROM `magento` WHERE `name` LIKE 'catalog_product_entity_text' \G;

# Create the new table
CREATE TABLE catalog_product_entity_text2 LIKE catalog_product_entity_text;

/*