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 vote159 views1 answer
Drop procedure sql
SQL
2 votes213 views2 answers
Create table mysql integer NOT null
SQL
0 vote162 views1 answer
Setval postgres example table id
SQL
0 vote201 views2 answers
SQL BULK INSERT
SQL
0 vote159 views1 answer
Mysql update from select on same table
SQL
1 vote207 views2 answers
Intersect sql
SQL
1 vote157 views1 answer
Oracle list constraints
SQL
0 vote154 views1 answer
Use between operator in mysql
SQL
1 vote175 views1 answer
Find difference in dates sql
SQL
0 vote211 views1 answer
Mariadb used space
SQL