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

3 votes290 views1 answer
Oracle sleep
SQL
0 vote294 views2 answers
Starts and end with vowel sql
SQL
1 vote284 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote285 views1 answer
Arithmetic expression in sql
SQL
12 votes279 views2 answers
Delete all entries postgres
SQL
0 vote296 views1 answer
Providername system.data. mysql
SQL
0 vote332 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote260 views1 answer
How to get inserted id in sql server
SQL
7 votes270 views4 answers
Database dump mysql command
SQL
4 votes258 views1 answer
Postgresql show current database
SQL