Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to create a variable in mysql

-- MySQL

SET @variable_name := value;
Comment

mysql declare variable

SET start = 1;
SET finish = 10;

SELECT * FROM places WHERE place BETWEEN start AND finish;
Comment

declare variable in mysql

SET @start = 1, @finish = 10;    
Comment

PREVIOUS NEXT
Code Example
Sql :: how to check nls format in oracle 
Sql :: DUPLICATE column values 
Sql :: edate dax 
Sql :: oracle sql first day of year 
Sql :: mysql show charset 
Sql :: oracle character index 
Sql :: delete top 100 rows in sql server 
Sql :: import sql file in mysql 
Sql :: mysql cli connect with password 
Sql :: mysql show data from table 
Sql :: oracle current timestamp insert statement 
Sql :: mysql show tables in database 
Sql :: insert random numbers in columns postgress 
Sql :: sql string_agg 
Sql :: how to count null values in mysql 
Sql :: oracle cannot access v$session 
Sql :: oracle sequence last_number 
Sql :: sql insert query 
Sql :: how to find date from date table in sql 
Sql :: sql query to find duplicate email address 
Sql :: host is not allowed to connect to this mysql server 
Sql :: show tables postgresql 
Sql :: sql server date now 
Sql :: find difference in dates sql 
Sql :: mysql convert column to uppercase 
Sql :: How to reset forgotten postgresql password 
Sql :: sql select data from last week 
Sql :: sql problems 
Sql :: ORA-00903 
Sql :: sql in sublime 
ADD CONTENT
Topic
Content
Source link
Name
1+5 =