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

2 votes195 views1 answer
Copy all values of a column to another column in sql in same table
SQL
27 votes205 views3 answers
Mysql show tables in database
SQL
0 vote183 views1 answer
Install mysql 8 linux
SQL
0 vote202 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
1 vote206 views1 answer
Too many connections mysql
SQL
0 vote213 views2 answers
Plpgsql
SQL
2 votes216 views2 answers
Sqlalchemy return id after insert
SQL
0 vote213 views3 answers
Join
SQL
5 votes208 views2 answers
Get number of columns sql
SQL
0 vote183 views1 answer
Go install mysql
SQL