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

13 votes312 views2 answers
Display users in mysql
SQL
0 vote327 views2 answers
Sqlite unique
SQL
0 vote325 views1 answer
Using GROUP BY in MySQL Join Table
SQL
3 votes324 views2 answers
WhereIn SQL
SQL
0 vote357 views1 answer
Check if record exists mysql
SQL
22 votes325 views4 answers
Mysql date format
SQL
1 vote341 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
25 votes332 views4 answers
Metadata
SQL
0 vote314 views1 answer
Sql query for getting data with join and count
SQL
0 vote359 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL