Amir Moeen Rahmani MrSinaRJ

👔

Working from office

OsamaShabrez / countries-with-iso.sql

Last active October 14, 2025 08:07

SQL Query to create a Countries table and insert all countries with their ISO

	CREATE TABLE `Countries` (
	`ID` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
	`NAME` CHAR(100) NOT NULL UNIQUE,
	`ISO` CHAR(2) NOT NULL UNIQUE
	);
	INSERT INTO Countries (Name, ISO) VALUES ('Afghanistan', 'AF');
	INSERT INTO Countries (Name, ISO) VALUES ('Albania', 'AL');
	INSERT INTO Countries (Name, ISO) VALUES ('Algeria', 'DZ');
	INSERT INTO Countries (Name, ISO) VALUES ('American Samoa', 'AS');
	INSERT INTO Countries (Name, ISO) VALUES ('Andorra', 'AD');

christofluethi / gist:646ae60d797a46a706a5

Last active April 30, 2025 20:03

Convert m4a to mp3 on OS X command line using ffmpeg

	brew update
	brew link yasm
	brew link x264
	brew link lame
	brew link xvid

	brew install ffmpeg

	ffmpeg wiki:
	https://trac.ffmpeg.org/wiki/Encode/MP3