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 vote206 views1 answer
Alter constraint postgres
SQL
5 votes147 views2 answers
To date oracle
SQL
7 votes156 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote160 views1 answer
How to check event scheduler status mysql
SQL
0 vote127 views1 answer
Incorrect datetime value sql table error 1292
SQL
0 vote135 views1 answer
Postgresql delete multiple rows
SQL
3 votes142 views1 answer
Sql insert inserted id
SQL
0 vote140 views1 answer
Mysql create table like
SQL
2 votes139 views1 answer
Oracle list duplicates
SQL
0 vote143 views1 answer
Oracle string substitution
SQL