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 vote249 views1 answer
Psotgres multiple values
SQL
4 votes286 views4 answers
Check constraint in ms sql
SQL
0 vote238 views1 answer
Select * where id = 1,2,3
SQL
-1 vote235 views3 answers
My sql alter table
SQL
11 votes246 views2 answers
Having clause in sql
SQL
10 votes238 views4 answers
How to alter table name in mysql
SQL
8 votes231 views3 answers
Alter user root mysql
SQL
1 vote224 views1 answer
Add time to date sql
SQL
-1 vote235 views1 answer
Mysql change database charset and collation
SQL
0 vote230 views2 answers
Transaction php
SQL