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

21 votes104 views5 answers
Oracle all tables
SQL
0 vote107 views1 answer
Exectuer myssql .sql
SQL
1 vote106 views1 answer
How to fetch alternate records from two tables
SQL
1 vote104 views1 answer
Sql sort column by date
SQL
1 vote103 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
11 votes94 views2 answers
Having clause
SQL
0 vote102 views1 answer
Show create table in postgresql
SQL
7 votes102 views2 answers
Oracle foreign key reference table
SQL
16 votes118 views5 answers
Select last row in sql
SQL
4 votes98 views2 answers
Oracle default date format
SQL