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

18 votes112 views6 answers
Laravel form validation
SQL
0 vote116 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote157 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote135 views1 answer
Delete a temporary table mysql
SQL
0 vote134 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
8 votes117 views4 answers
Postgresql server restart
SQL
1 vote131 views2 answers
Begin transaction in sql
SQL
0 vote126 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
5 votes119 views2 answers
Oracle list columns
SQL
2 votes133 views2 answers
Null column to 0 in mysql
SQL