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 votes240 views4 answers
Show databases in sql server
SQL
4 votes206 views1 answer
Sql list users and roles
SQL
2 votes235 views1 answer
Postgresql drop primary key constraint
SQL
-1 vote233 views1 answer
Window functions in sql
SQL
0 vote242 views1 answer
Allow external access to mysql
SQL
6 votes239 views1 answer
Wordpress change user password sql
SQL
0 vote276 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote240 views3 answers
Database restoring error
SQL
0 vote276 views1 answer
Dual in db2
SQL
2 votes246 views2 answers
Mysql on duplicate key update get value from values
SQL