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

20 votes216 views6 answers
Mysql reset auto increment
SQL
0 vote213 views1 answer
Mssql dockere
SQL
0 vote214 views1 answer
Xampp mysql version
SQL
0 vote219 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote212 views1 answer
Psql datestyle
SQL
10 votes193 views1 answer
Oracle view dependencies
SQL
0 vote265 views1 answer
Sql commands in android
SQL
4 votes206 views1 answer
Data types in sql
SQL
2 votes226 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote318 views1 answer
How to show current database in mysql
SQL