Literals:
SET var_Name = ‘ALEXANDRE’
In the example above we’ve assigned the literal ALEXANDRE to the var_Name variable. We can say that the content (or meaning) of var_Name is ALEXANDRE.
Ah! Got it!!! Everything between quotes is a literal. Not so fast. The analogy is good but imperfect.
SET var_I_like_move_move_it = FALSE;
SET @var_Price = 10;
SET @Qty = 3;
SET @Total = @var_Price * @Qty;
FALSE (0) is a literal that has been assigned to var_I_like_move_move_it. Although my children love Madagascar, and, I am sympathetic to King Julien, I don’t like to dance. Therefore, FALSE (0 in MySQL) describes the contents of the variable to which it was assigned.
So a literal can be of any type: string, numbers, dates, booleans, or even binary.
SELECT * FROM tab_1 WHERE purchase_date > = ‘2020-01-01’
The literal ‘2020-02-01’ was used to make a comparison with the purchase date, making it possible to filter the data from table tab_1.
Check out more articles like this one Blog.
Give it a try for 14 days, no burocracy, no credit card
Learn more about Flightdeck!
