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 vote147 views1 answer
Convert to hexadecimal sql
SQL
5 votes122 views1 answer
Ora-00054 find lock
SQL
0 vote154 views1 answer
Kill mysqld_safe process mariadb
SQL
0 vote138 views1 answer
What is between keyword used for
SQL
0 vote144 views2 answers
Faster mysql imports
SQL
16 votes136 views1 answer
Mssql int max value
SQL
0 vote138 views2 answers
Select index table oracle
SQL
1 vote149 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
1 vote123 views1 answer
Using SQL in rails migration
SQL
1 vote138 views1 answer
Mysql decimal allow negative values?
SQL