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

1 vote278 views1 answer
Oracle stop job
SQL
-1 vote302 views2 answers
Sql truncate number
SQL
4 votes283 views1 answer
Sql delete where in select
SQL
2 votes289 views1 answer
Mysql create user with mysql_native_password
SQL
5 votes294 views1 answer
Sql select ciunt
SQL
1 vote300 views1 answer
Psql human readable
SQL
10 votes301 views4 answers
Drop primary key
SQL
1 vote273 views1 answer
Sql try catch
SQL
20 votes326 views4 answers
How to find average in sql
SQL
0 vote276 views1 answer
Hive batch drop table
SQL