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 vote223 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote215 views1 answer
Mysql could not fetch tables
SQL
13 votes246 views3 answers
List all the tables in sql
SQL
0 vote235 views1 answer
Python mysql show databases
SQL
0 vote226 views1 answer
Get relation data in mysql using query to excel
SQL
1 vote226 views1 answer
Get create table query existing table mysql
SQL
0 vote214 views1 answer
Get week day name sql server
SQL
-1 vote202 views2 answers
How to display top 50 rows?
SQL
0 vote261 views1 answer
How to subquey to do not load in live database in
SQL
0 vote207 views2 answers
How to find max and min salary in sql
SQL