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 vote188 views1 answer
Oracle index hint multiple tables example
SQL
1 vote211 views1 answer
Oracle undo usage per session
SQL
0 vote209 views1 answer
Show database not empty tables postgres
SQL
1 vote211 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
21 votes199 views3 answers
Average sql
SQL
7 votes213 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
9 votes205 views5 answers
Sql limit
SQL
0 vote204 views1 answer
Data types mysql vs postgresql
SQL
0 vote204 views1 answer
SqlFunction does not exist
SQL
0 vote193 views1 answer
Redirection 301 htaccess nom de domaine
SQL