nisar1

 jQuery('.barmenu').click(function () {
      var lwidth = '260px';
      
      if (!jQuery(this).hasClass('open')) {
          jQuery('.rightpanel, .headerinner, .topbar').css({ marginLeft: lwidth }, 'fast');
          jQuery('.leftpanel').css({ marginLeft: 0 }, 'fast');
          jQuery(this).addClass('open');
      } else {
          jQuery('.rightpanel, .headerinner, .topbar').css({ marginLeft: 0 }, 'fast');
          jQuery('.leftpanel').css({ marginLeft: '-' + lwidth }, 'fast');

nisar1

jQuery(document).ready(function () {
  jQuery.fn.clickToggle = function (func1, func2) {
        var funcs = [func1, func2];
        this.data('toggleclicked', 0);
        this.click(function () {
            var data = jQuery(this).data();
            var tc = data.toggleclicked;
            jQuery.proxy(funcs[tc], this)();
            data.toggleclicked = (tc + 1) % 2;
        });

nisar1

-- Lists sp,tbl,fn in a dbz

--show procedure
SHOW PROCEDURE STATUS WHERE Db = DATABASE() AND TYPE = 'PROCEDURE';
SHOW FUNCTION STATUS WHERE Db = DATABASE() ;
select name from mysql.proc where db = database();

--list keys
select *
from INFORMATION_SCHEMA.TABLE_CONSTRAINTS

nisar1

According to the MySQL docs you can only cast to: 

    BINARY[(N)]
    CHAR[(N)]
    DATE
    DATETIME
    DECIMAL[(M[,D])]
    SIGNED
    [INTEGER]
    TIME