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 vote195 views1 answer
Java nosql sort
SQL
0 vote163 views1 answer
How to retrive the today date sql
SQL
1 vote153 views1 answer
Select random sample sql
SQL
3 votes179 views3 answers
Postgresql random number
SQL
7 votes191 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
1 vote167 views1 answer
Postgres cast as currency format
SQL
0 vote178 views1 answer
Convert excel into sqllite db using python
SQL
0 vote232 views1 answer
Mysql get longest string in column
SQL
20 votes192 views1 answer
Get all table name in sql through php
SQL
1 vote171 views1 answer
Md5 encryption for existing records
SQL