Advanced Search

Return to Snippet

Revision: 24162
at February 22, 2010 12:28 by sukantahazra
Initial Code 
show engines;  # to get supported engines

show table status where name = 'tablename';  # to get the table status

alter table tablename engine = enginename ; # to set to MyISAM or InnoDB, etc.
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
General MySQL engine related commands

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
MySQl table engine

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, table

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL