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

2 votes126 views1 answer
Mysql shell insert into
SQL
0 vote121 views1 answer
MySQL - How to find word with the most similar beginning
SQL
13 votes111 views5 answers
Oracle list tables
SQL
0 vote118 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote111 views1 answer
Mysql DDL
SQL
0 vote154 views1 answer
Grouping by email domain mysql
SQL
0 vote111 views1 answer
Oracle query archive mode
SQL
10 votes109 views6 answers
Mysql delete duplicates
SQL
0 vote158 views1 answer
Sql check if field is not null
SQL
0 vote105 views1 answer
Sql select maximum column with other columns returned
SQL