Skip to content

Instantly share code, notes, and snippets.

Gurban Gurbanov BumbuKhan

Block or report user

Report or block BumbuKhan

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@vladimirtsyupko
vladimirtsyupko / gist:10964772
Created Apr 17, 2014
Git force pull to overwrite local files
View gist:10964772
git fetch --all
git reset --hard origin/master
git pull origin master
@esaounkine
esaounkine / distance_between.sql
Created Sep 23, 2011
Calculate distance between two points with MySQL
View distance_between.sql
CREATE FUNCTION distance_between (from_lat DECIMAL(6, 3), from_lng DECIMAL(6, 3), to_lat DECIMAL(6, 3), to_lng DECIMAL(6, 3)) RETURNS DECIMAL(11, 3)
RETURN 6371 * 2 * ATAN2(SQRT(POW(SIN(RADIANS(to_lat - from_lat)/2), 2) + POW(SIN(RADIANS(to_lng - from_lng)/2), 2) * COS(RADIANS(from_lat)) * COS(RADIANS(to_lat))), SQRT(1 - POW(SIN(RADIANS(to_lat - from_lat)/2), 2) + POW(SIN(RADIANS(to_lng - from_lng)/2), 2) * COS(RADIANS(from_lat)) * COS(RADIANS(to_lat))));
You can’t perform that action at this time.