Skip to content

Instantly share code, notes, and snippets.

View alivx's full-sized avatar
😇
our business is life itself

Ali alivx

😇
our business is life itself
View GitHub Profile
@alivx
alivx / getTableSize.sql
Created April 5, 2020 13:57
Get mysql table size in MB
SELECT table_name AS "Table",
ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)"
FROM information_schema.TABLES
WHERE table_schema = "alidb"
ORDER BY (data_length + index_length) DESC;
@alejzeis
alejzeis / timezone-mappings.csv
Created March 15, 2017 00:12
Linux-Windows Timezone Mappings CSV
AUS Central Standard Time 001 Australia/Darwin
AUS Central Standard Time AU Australia/Darwin
AUS Eastern Standard Time 001 Australia/Sydney
AUS Eastern Standard Time AU Australia/Sydney Australia/Melbourne
Afghanistan Standard Time 001 Asia/Kabul
Afghanistan Standard Time AF Asia/Kabul
Alaskan Standard Time 001 America/Anchorage
Alaskan Standard Time US America/Anchorage America/Juneau America/Metlakatla America/Nome America/Sitka America/Yakutat
Aleutian Standard Time 001 America/Adak
Aleutian Standard Time US America/Adak
USB drive as FAT32 on a Win7/Win8/Win10
diskpart.exe
list disk (Find USB device)
select disk 1 (select USB drive)
clean
create partition primary
select partition 1
active
format quick fs=fat32 (UEFI can only USB boot to FAT32, not NTFS)