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 vote123 views1 answer
Shrink database file in sql server
SQL
1 vote124 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
2 votes115 views2 answers
Join update query in sql
SQL
13 votes116 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
13 votes125 views2 answers
Oracle select into and inner join
SQL
0 vote127 views1 answer
Mysql in clausule string array
SQL
0 vote124 views1 answer
Set default value now() date
SQL
1 vote133 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
1 vote130 views1 answer
Select not matching data from two tables
SQL
0 vote136 views1 answer
Oracle list partitions
SQL