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 vote274 views1 answer
Import sql file from laravel
SQL
34 votes192 views6 answers
Alter table add foreign key mysql
SQL
0 vote154 views2 answers
Py sqlite if entry exists
SQL
2 votes150 views1 answer
Mysql Incorrect column specifier for column
SQL
16 votes145 views2 answers
Mysql date between two dates
SQL
0 vote106 views1 answer
Check if due date is less than todays date sql
SQL
5 votes160 views1 answer
Get table columns from sql
SQL
0 vote168 views1 answer
Leftjoin in sql
SQL
1 vote151 views1 answer
How to check the mysql version mac
SQL
0 vote151 views1 answer
Incorrect string value: mysql
SQL