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 vote235 views1 answer
Where date in datetime mysql
SQL
0 vote212 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote195 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote200 views1 answer
Select last 2 characters sql
SQL
0 vote268 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote204 views1 answer
Oracle sql date summer time
SQL
10 votes188 views2 answers
Sql merge statement
SQL
0 vote175 views1 answer
Postgresql add leading zeros
SQL
0 vote216 views1 answer
Dump db only triggers mysql
SQL
7 votes211 views5 answers
Oracle alter table
SQL