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 vote183 views1 answer
Oracle update with sequence
SQL
0 vote198 views1 answer
Compare subqueries oracle
SQL
1 vote191 views1 answer
Retrieve meaning
SQL
1 vote201 views1 answer
Group_concat order by
SQL
0 vote182 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote170 views1 answer
Postgresql parse json array
SQL
0 vote185 views1 answer
Sql trying to delete database in use
SQL
0 vote215 views1 answer
Sql quary stuf
SQL
0 vote183 views1 answer
Mysql beautifier terminla
SQL
0 vote175 views1 answer
Sql select first and last record of each group
SQL