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 vote198 views1 answer
How to move a column to different spot mysql
SQL
12 votes192 views1 answer
Docker run mysql image
SQL
0 vote181 views1 answer
Create table sql generator
SQL
0 vote196 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
4 votes242 views1 answer
Oracle change nls_date_format permanently
SQL
3 votes207 views1 answer
Oracle undo tablespace schema
SQL
0 vote236 views1 answer
CONVERT time string into 12 hours in sql
SQL
13 votes182 views2 answers
Oracle select into and inner join
SQL
0 vote188 views2 answers
Sql query inner join 3 tables
SQL
1 vote201 views1 answer
Tsql update datetime
SQL