Advanced Search

Return to Snippet

Revision: 32421
at September 24, 2010 05:33 by matula
Initial Code 
ALTER TABLE tablename AUTO_INCREMENT = 1
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
for auto increment ids, when you delete records this will reset the number for the next auto id.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Reset MySQL Auto Increment number

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL