How to alias a field or column in MySQL?

by

select @code:= SUM(field1 + field2), @code+1 from abc;

But, please be aware of the following (from the MySQL 5.6 docs):

As a general rule, other than in SET statements, you should never assign a value to a user variable and read the value within the same statement. For example, to increment a variable, this is okay:

SET @a = @a + 1;

For other statements, such as SELECT, you might get the results you expect, but this is not guaranteed. In the following statement, you might think that MySQL will evaluate @a first and then do an assignment second:

SELECT @a, @a:=@a+1, ...;

However, the order of evaluation for expressions involving user variables is undefined.

So, use at your own risk.

More Related Contents:

  1. What is better subquery vs literal on IN clause in mysql
  2. Getting the SUM() of claps and at the same time counting bookmarks in one query
  3. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  4. Remove duplicate rows in MySQL
  5. What is the error “Every derived table must have its own alias” in MySQL?
  6. Get records with highest/smallest per group
  7. MySQL DELETE FROM with subquery as condition
  8. CROSS/OUTER APPLY in MySQL
  9. Subqueries with EXISTS vs IN – MySQL
  10. MySQL/MariaDB – order by inside subquery
  11. MySQL – SELECT WHERE field IN (subquery) – Extremely slow why?
  12. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  13. MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?
  14. Find date range overlaps within the same table, for specific user MySQL
  15. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  16. MySQL OPTIMIZE all tables?
  17. Strip last two characters of a column in MySQL
  18. What’s mysql’s “BETWEEN” performance over..?
  19. MySQL: set field default value to other column
  20. CREATE command denied to user？
  21. Laravel MySql DB Connection with SSH
  22. Automatic Rollback if COMMIT TRANSACTION is not reached
  23. Get column sum and use to calculate percent of total (mySQL)
  24. is there a length limit to group_concat or another reason why it would not work on a text field
  25. MySQL cartesian product between two SELECT statements
  26. Deleting a row based on the max value
  27. Sum until certain point – MySql
  28. mysql double-quoted table names
  29. MySQL giving “read ECONNRESET” error after idle time on node.js server
  30. Speeding up mysql dumps and imports [closed]

Leave a Comment