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

7 votes268 views4 answers
Mysql delete older duplicates
SQL
1 vote279 views2 answers
Regex starts with
SQL
0 vote285 views1 answer
Postgresql show owner of database
SQL
0 vote293 views1 answer
Postgresql create table many-to-many
SQL
0 vote270 views1 answer
Cast float mysql
SQL
0 vote287 views2 answers
Homebrew nysql launch
SQL
2 votes298 views1 answer
Postgresql create table as select
SQL
0 vote287 views1 answer
Mysql listing get a particu particular user firsdt
SQL
2 votes267 views1 answer
Pandas to sql index
SQL
-1 vote270 views1 answer
Su: Authentication failure mysql
SQL