If you are not able to download the excel in Firefox and where it is working fine in Chrome and IE then have a look at below code. To work in Firefox Excel Issue Just add below code in headersheader(“Content-type: application/vnd.ms-excel”); See below for full code header(“Content-disposition: attachment;filename=example.xls”);header(“Content-type: application/vnd.ms-excel”);header(“Pragma: public”);header(“Expires: 0”);header(“Cache-Control: must-revalidate, post-check=0, pre-check=0”);header(“Cache-Control: private”, […]
The maximum value for decimal(5,3) is 99.999, it means 5 digits with 3 digits after decimal, and whenever you try to insert or update more than 99.999 value it is automatically capped to 9.99 in mysql. This Try decimal(5, 2) Decimal(5,3) is used for financial values or less than 100% values. If you want to […]
To Get Data Base Size in MB and Free Space in MBSELECT table_schema “dbName”, sum( data_length + index_length ) / 1024 / 1024 “Data Base Size in MB”, sum( data_free )/ 1024 / 1024 “Free Space in MB”FROM information_schema.TABLESGROUP BY table_schema ; To Get Size in GB: SELECT sum(round(((data_length + index_length) / 1024 […]
