MySQL

MySQL: Table size query

Posted on

    SELECT TABLE_NAME, table_rows, data_length, index_length, ROUND(((data_length + index_length) / 1024 / 1024),2) ‘Size in MB’ FROM information_schema.TABLES WHERE table_schema = ‘mallagroup_mautic’ ORDER BY ROUND(((data_length + index_length) / 1024 / 1024),2) DESC ;

MySQL

MySQL: Replace Accented Characters

Posted on

UPDATE leads_cstm SET linkedin_name_c = REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE(REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE(REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE(linkedin_name_c,’ù’,’u’),’ú’,’u’),’û’,’u’),’ü’,’u’),’ý’,’y’),’ë’,’e’),’à’,’a’),’á’,’a’),’â’,’a’),’ã’,’a’),’ä’,’a’),’å’,’a’),’æ’,’a’),’ç’,’c’),’è’,’e’),’é’,’e’),’ê’,’e’),’ë’,’e’),’ì’,’i’),’í’,’i’),’î’,’i’),’ï’,’i’),’ð’,’o’),’ñ’,’n’),’ò’,’o’),’ó’,’o’),’ô’,’o’),’õ’,’o’),’ö’,’o’),’ø’,’o’);