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 vote191 views1 answer
Sql select upcoming birthdays
SQL
0 vote185 views1 answer
Mysql add comment to column
SQL
0 vote205 views1 answer
Sql server convert to guid
SQL
0 vote224 views1 answer
Import mysql'
SQL
2 votes294 views1 answer
Oracle run_duration to number
SQL
2 votes188 views2 answers
Oracle no data found error code
SQL
3 votes181 views2 answers
Current year sql
SQL
0 vote192 views1 answer
Mysql join same table multiple times group by
SQL
0 vote189 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote189 views1 answer
Back up stored procedures mysql
SQL