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

4 votes202 views2 answers
Mysql delete user if exists
SQL
1 vote184 views1 answer
Postgres set column equal to another
SQL
1 vote271 views1 answer
Oracle transaction rollback not working
SQL
4 votes197 views1 answer
Adding data to table in sql python
SQL
5 votes212 views4 answers
Traduction
SQL
7 votes194 views1 answer
Query postgres delete duplicates
SQL
8 votes189 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote185 views1 answer
Set a default value for a column in sqlite
SQL
0 vote200 views1 answer
Oracle job schedules
SQL
1 vote171 views3 answers
Grant syntax in sql
SQL