Skip to content

Instantly share code, notes, and snippets.

Avatar

Gurban Gurbanov BumbuKhan

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.