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 vote344 views1 answer
List mysql tables and views
SQL
1 vote366 views1 answer
Oracle drop job if exists
SQL
0 vote355 views2 answers
Athena drop partition
SQL
0 vote344 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
1 vote349 views2 answers
ImportError: No module named mysql.connector
SQL
0 vote364 views2 answers
How to take recent row without limit in mysql
SQL
1 vote357 views1 answer
Oracle duration between timestamps
SQL
8 votes373 views1 answer
Sql remove leading spaces
SQL
0 vote369 views1 answer
Mysql drop trigger
SQL
0 vote387 views1 answer
Mysql last friday of current month
SQL