Change the Storage Engine in mysql

Query to get total number of records
Select count (*) from mytable;

Query to change the storage engine
ALTER TABLE mytable ENGINE = innodb

Comments

Post a Comment

Popular posts from this blog

Spring MVC- Redirect from one controller to another

In spring mvc its very easy to redirect from one controller to another controller Example : @Controller @RequestMapping("/springcontroller1") public class SpringController1{ } @Controller public class SpringController2{ //thinking of redirecting on clicking on a method @RequestMapping(value = "/SpringController2cancel.abc", method = RequestMethod.POST, params = "action=cancel")     public ModelAndView cancel(@ModelAttribute("MyForm") MyForm myForm, BindingResult errors,SessionStatus sessionStatus,HttpServletRequest request) throws MyException {         ModelAndView modelAndView = new ModelAndView();                 sessionStatus.setComplete();         //redirecting to controller1         return new ModelAndView("redirect:/springcontroller1.abc");     } }
Read more

How to retain the space of the td after hidding it in Jquery

Image
If you use the following code snippet to hide and show tds- the UI will get disturbed. The next corresponding td will get shifted to the hidden td space.    var tablevar="#"+myTable;  $(tablevar+' tr:eq('+i+')').find('td:eq(3)').show();    $(tablevar+' tr:eq('+i+')').find('td:eq(2)').show(); So how to retain the td space and still achieve the functionality. use the this code snippet.    var tablevar="#"+myTable; $(tablevar+' tr:eq('+i+')').find('td:eq(3)').css("visibility", "hidden");  $(tablevar+' tr:eq('+i+')').find('td:eq(2)').css("visibility", "hidden");  $(tablevar+' tr:eq('+i+')').find('td:eq(4)').css("visibility", "visible");
Read more