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

5 votes343 views5 answers
Find max number in sql
SQL
11 votes371 views5 answers
Laravel db facade
SQL
1 vote348 views1 answer
Oracle grant on all tables in schema
SQL
0 vote373 views1 answer
Sqlite unique multiple columns
SQL
0 vote349 views1 answer
DATEDIFF minute postgres
SQL
0 vote373 views1 answer
Pl/pgsql declare variable
SQL
1 vote323 views1 answer
Sql oracle update multiple rows
SQL
0 vote340 views1 answer
Sql select max value for each group
SQL
0 vote347 views1 answer
Psql datestyle
SQL
2 votes342 views1 answer
Postgresql change value in column
SQL