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

0 vote272 views1 answer
Execut sql python
SQL
8 votes252 views1 answer
Alter tablespace add datafile
SQL
0 vote248 views1 answer
Sql change default collation to utf8
SQL
5 votes233 views1 answer
Mongodb vs
SQL
6 votes260 views2 answers
Where clause in sql
SQL
0 vote267 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
18 votes260 views6 answers
Mysql create table
SQL
1 vote259 views1 answer
Create table variable in sql stored procedure
SQL
0 vote288 views1 answer
Sql quary stuf
SQL
0 vote291 views1 answer
Command line mysql xampp
SQL