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

3 votes117 views2 answers
Tsql join multiple record in one string
SQL
0 vote143 views1 answer
Sql date time query find
SQL
2 votes118 views2 answers
Set database timezone mysql
SQL
11 votes121 views2 answers
Oracle saurce code
SQL
3 votes119 views1 answer
Laravel paginate raw sql
SQL
1 vote111 views1 answer
Oracle truncate partition
SQL
0 vote106 views1 answer
Mysql update sequence with order by
SQL
1 vote224 views2 answers
Postgres select from last 3 months
SQL
0 vote127 views1 answer
Sql order by except one row
SQL
3 votes238 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL