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

-1 vote353 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
1 vote308 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
9 votes336 views3 answers
Date format in sql
SQL
1 vote328 views1 answer
Deleting database in sql
SQL
3 votes292 views1 answer
Oracle nextval
SQL
0 vote309 views1 answer
Sql server express download
SQL
0 vote306 views1 answer
How to get initials in sql
SQL
2 votes331 views1 answer
Q operator in sql
SQL
1 vote313 views1 answer
Rermove categories woocommerce sql
SQL
0 vote336 views1 answer
Create a sql server database programmatically
SQL