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 vote94 views1 answer
Avg mysql
SQL
0 vote101 views2 answers
Show slave status mysql
SQL
1 vote108 views3 answers
Execute sp in sql server
SQL
13 votes103 views2 answers
Sql count distinct group by
SQL
1 vote294 views1 answer
Postgres upgrade to superuser
SQL
3 votes146 views1 answer
Query less than datetime sql
SQL
9 votes109 views2 answers
SELECT User,Host FROM mysql.user;
SQL
2 votes115 views1 answer
How to get non distinct values in sql
SQL
0 vote146 views1 answer
Drop domain postgresql
SQL
1 vote104 views2 answers
Limit sqlserver
SQL