7z x filename.zip extract all zip archives 7z x *.zip to unzip on specific location or folder 7z x filename.zip foldername 7z x *.zip foldername Install 7zip on Linux Centos yum install p7zip Install 7zip on Linux Ubuntu sudo apt-get install p7zip a to archive $ 7za a myfiles.7z myfiles/
MySQL provides a LIMIT clause that is used to specify the number of records to return. The LIMIT clause makes it easy to code multi page results or pagination with SQL, and is very useful on large tables. Assume we wish to select all records from 1 – 30 (inclusive) from a table called “Orders”. […]
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 […]
