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

3 votes171 views2 answers
Postgres show table schema
SQL
0 vote173 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote175 views1 answer
Sql get guid
SQL
12 votes217 views10 answers
Google
SQL
-1 vote165 views3 answers
Create temp table in sql
SQL
0 vote176 views1 answer
Mysql drop trigger
SQL
1 vote207 views1 answer
Postgresql if 0 then 1
SQL
1 vote175 views1 answer
Median mysql
SQL
1 vote162 views1 answer
Oracle select first result
SQL
1 vote169 views1 answer
How to subtract from the value of a table in sql
SQL