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 vote375 views1 answer
Postgresql inheritance
SQL
2 votes356 views2 answers
Install postgresql
SQL
0 vote333 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
51 votes452 views6 answers
Change column name sql
SQL
0 vote342 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
0 vote400 views1 answer
Drop view in mysql
SQL
0 vote390 views1 answer
Mariadb cast to int
SQL
2 votes362 views1 answer
Search query in mysql
SQL
0 vote342 views1 answer
How to set all the min and sec data to zero in sql server
SQL
1 vote372 views1 answer
Set id count mysql
SQL