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 vote140 views1 answer
Drop a field in psql django
SQL
0 vote137 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote152 views1 answer
Sql max of two values
SQL
0 vote132 views1 answer
Sql clear table
SQL
0 vote158 views1 answer
TSQL convert csv to table
SQL
1 vote147 views1 answer
Change table to innodb mysql
SQL
1 vote133 views1 answer
Substr sql last character
SQL
0 vote161 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
11 votes148 views4 answers
Update row in mysql
SQL
0 vote148 views1 answer
How to import pymysql through jupyter notebook for windows
SQL