MYSQL stored procedure select from

DELIMITER |
CREATE PROCEDURE getNearestCities(IN cityID INT)
    BEGIN
        DECLARE cityLat FLOAT;
        DECLARE cityLng FLOAT;
        SET cityLat = SELECT cities.lat FROM cities WHERE cities.id = cityID;
        SET cityLng = SELECT cities.lng FROM cities WHERE cities.id = cityID;
        SELECT *, HAVERSINE(cityLat,cityLng, cities.lat, cities.lng) AS dist FROM cities ORDER BY dist LIMIT 10;
    END |

-1

Source: stackoverflow.com

Similar codes

0 vote105 views1 answer
Find usage of table in sql server
SQL
0 vote112 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
1 vote97 views1 answer
Trigger in postgresql to change incoming entry
SQL
0 vote155 views1 answer
Placements hackerrank solution
SQL
1 vote103 views1 answer
MySQL AND Operator
SQL
0 vote108 views1 answer
Mql5 datetime get hour
SQL
1 vote105 views2 answers
Pl sql case
SQL
1 vote102 views2 answers
How to search date in sql query
SQL
2 votes106 views2 answers
Run mysql command from bash
SQL
0 vote123 views1 answer
Sql query inline if
SQL