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 vote257 views1 answer
Contact mysql column field
SQL
4 votes242 views2 answers
Oracle unliock account
SQL
1 vote256 views1 answer
Mysql change root mysql_native_password
SQL
0 vote249 views1 answer
Update table sql multiple set
SQL
1 vote264 views2 answers
Remove space in mysql
SQL
19 votes255 views2 answers
Mysql add column after another
SQL
3 votes254 views2 answers
Laravel tosql with bindings
SQL
0 vote570 views1 answer
Create pl/sql stored procedure
SQL
0 vote292 views2 answers
Insert data mysql with cmd
SQL
0 vote291 views1 answer
For select oracle
SQL