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 vote124 views1 answer
How to set field to null in sql
SQL
0 vote186 views1 answer
Renommer base sql
SQL
1 vote2.7K views1 answer
Dropping a constraint in ms sql
SQL
0 vote172 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
21 votes232 views6 answers
Update sql
SQL
0 vote151 views1 answer
Insert thai language sql server
SQL
5 votes161 views4 answers
Describe table postgres
SQL
6 votes158 views4 answers
Delete table sqlite
SQL
3 votes178 views1 answer
Oracle list privileges
SQL
0 vote169 views1 answer
Ignore case in string sql
SQL