Truncate (Empty) a Table

Removes all rows from a table and resets AUTO_INCREMENT. Faster than DELETE FROM because it does not log individual row deletions.

Variables

Command


        

    







    2 views
    0 copies
    





    
    Log in to rate




    

        
Related in this category

        

                                                
                        Install MariaDB server
                    
                                                                
                        MariaDB secure installation
                    
                                                                
                        Create MariaDB database, user, and grants
                    
                                                                
                        Backup MariaDB database to .sql file
                    
                                    

    





        

        
            
                
            
            Log in to save
        
        
Free account — save snippets into your own collections.