Mukesh Chapagain chapagain

## fix_auto_increment_exhaustion.sql
# 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;

/*

## Titanic.ipynb

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                chapagain
                / Titanic.ipynb
            
            
              Created
              November 1, 2017 06:59
            
              
                Titanic: Machine Learning from Disaster
              
          
        
      
        
  
    
    

          
    
      
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
	# 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;

	/*