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 vote332 views1 answer
Generate sequence number in sql server
SQL
0 vote365 views1 answer
Sql query to find duplicate email address
SQL
0 vote392 views1 answer
For select oracle
SQL
2 votes353 views2 answers
Mysql date range
SQL
0 vote398 views1 answer
Date 3 months from today sql
SQL
3 votes371 views1 answer
How to find names includes in sql
SQL
0 vote366 views4 answers
What is unique key in sql
SQL
6 votes352 views2 answers
Return columns from table sql
SQL
1 vote375 views1 answer
Sql server cast date dd/mm/yyyy
SQL
4 votes347 views3 answers
Mysql varchar length
SQL