Sponsored Links
And 'possible to create a variable inside a query?
Yes, the syntax for creating a variable is as follows:
SET @ varname = value;Here's an example:
Miavar SET @ = 1; SELECT @ miavar;It 'can also assign the value to the variable within a SELECT statement, an example follows:
Miavar SET @ = 1; SELECT @ miavar: miavar + 9 = @;This query will produce results in 10 as the new value of @ miavar.
Note that the SELECT statement in the assignment of value is done by the operator: = and not simply equal (=).
In the same category ...
- MySQL has a similar function ucfirst () in PHP to convert a string to lower case with only the first letter capitalized?
- How do I count the occurrences of a character within a field?
- How do I delete an index from a table?
- What is the difference between the indices (INDEX) and keys (KEY)?
- How do I add an index to a table?
E-Learning
 |
MS Access (Advanced)
Learn how to create and manage databases quickly and easily. Starting from 29 €. |
 |
MySQL (Course)
Management of open-source database. From 39 €. |
 |
SQL and Database (Course)
Create and manage relational databases. From 39 €. |
Sponsored Links