/SQL/Mysql declare variable

Mysql declare variable

Mysql declare variable

SET start = 1;
SET finish = 10;

SELECT * FROM places WHERE place BETWEEN start AND finish;

3

Source: stackoverflow.com

Declare variable in mysql

SET @start = 1, @finish = 10;

0

Source: stackoverflow.com

Mysql declare variable

how to see the variable after to declare

0

Similar codes

11 votes68 views1 answer
Reset identity sql server
SQL
1 vote133 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote124 views1 answer
Mysql random number between 1 and 100
SQL
0 vote129 views1 answer
Sqlalchemy get schema from database
SQL
-1 vote116 views1 answer
What is in operator
SQL
104 votes295 views2 answers
Like in mysql
SQL
0 vote140 views1 answer
Add a new column into table
SQL
1 vote133 views1 answer
Sqlite update from another table
SQL
0 vote111 views1 answer
How to find username and password in oracle 18c
SQL
0 vote144 views1 answer
Mysqldump: error:
SQL

Share