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 vote193 views1 answer
Create table using the clause with as
SQL
2 votes232 views1 answer
How to get non distinct values in sql
SQL
5 votes199 views3 answers
Day of week postgresql
SQL
1 vote177 views2 answers
ImportError: No module named mysql.connector
SQL
0 vote211 views1 answer
Error code 1451 sql
SQL
5 votes258 views1 answer
Oracle sysdate - 1 month
SQL
1 vote148 views2 answers
Delete auto increment mysql
SQL
6 votes186 views2 answers
Drop foreign key
SQL
0 vote176 views1 answer
Change database name psql 8
SQL
0 vote191 views1 answer
Sqlite explain plan
SQL