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 vote100 views1 answer
Psql kill pid
SQL
2 votes194 views2 answers
Create table mysql integer NOT null
SQL
0 vote152 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
14 votes135 views2 answers
How to auto increment in sql
SQL
0 vote152 views1 answer
Except in sql alchemy
SQL
4 votes133 views2 answers
Sql table
SQL
0 vote142 views2 answers
How to save result of sqlite query in a table
SQL
0 vote163 views1 answer
Executescalar in sql server
SQL
3 votes149 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
1 vote161 views1 answer
Mysql update inner
SQL