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 vote149 views1 answer
Mysql select month and year
SQL
1 vote170 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote184 views1 answer
Mysql changer nom table
SQL
0 vote157 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
0 vote145 views1 answer
How to connect pgadmin with excel
SQL
0 vote163 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote149 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
0 vote152 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
17 votes163 views3 answers
Postgresql version command
SQL
15 votes144 views7 answers
MYSQL
SQL