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 vote341 views1 answer
Mysql insert multiple rows based on select
SQL
1 vote286 views1 answer
How much every mysql database record takes from diskspace
SQL
2 votes304 views4 answers
2nd highest salary in mysql
SQL
0 vote287 views1 answer
Create or replace view postgress
SQL
4 votes273 views1 answer
SQL order random
SQL
0 vote300 views1 answer
Sql date d'aujourd'hui
SQL
0 vote274 views1 answer
Parsing float to int in mysql
SQL
0 vote293 views1 answer
How convert into in in sql query
SQL
14 votes306 views3 answers
Delete all records from table except sql
SQL
4 votes302 views1 answer
Mysql ip address data type
SQL