Can I reuse a calculated field in a SELECT query?

by

Yes, you can reuse variables. This is how you do it: 

SELECT 
    @total_sale := s.f1 + s.f2 as total_sale, 
    s.f1 / @total_sale as f1_percent
FROM sales s

Read more about it here: http://dev.mysql.com/doc/refman/5.0/en/user-variables.html

[Note: This behavior is undefined. According to the MySQL docs:]

As a general rule, you should never assign a value to a user variable and read the value within the same statement. You might get the results you expect, but this is not guaranteed.

More Related Contents:

  1. Using column alias in WHERE clause of MySQL query produces an error
  2. Unknown Column In Where Clause
  3. Unknown column in ‘field list’ error on MySQL Update query
  4. get first occurrence of last changed value of a column [closed]
  5. SQL Print the name of all Employees together with the name of their supervisor
  6. MySQL – Rows to Columns
  7. ROW_NUMBER() in MySQL
  8. Left Outer Join doesn’t return all rows from my left table?
  9. How can I temporarily disable a foreign key constraint in MySQL?
  10. MySQL offset infinite rows
  11. Ordering by the order of values in a SQL IN() clause
  12. Creating a “Numbers Table” in MySQL
  13. SQL Selecting from two Tables with inner join and limit [duplicate]
  14. Can a foreign key reference a non-unique index?
  15. MySQL Group by SUM
  16. Compare dates in MySQL
  17. Why do results from a SQL query not come back in the order I expect?
  18. MySQL combine two columns and add into a new column
  19. Invalid default value for ‘dateAdded’
  20. How to set a MySQL row to READ-ONLY?
  21. Split a string and loop through values in MySQL stored procedure
  22. How to create dummy variable columns for thousands of categories in Google BigQuery?
  23. MySQL Select Query – Get only first 10 characters of a value
  24. Most efficient way to store IP Address in MySQL [duplicate]
  25. Getting first day of the week in MySql using Week No
  26. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  27. mysql select id and name from other table and join query
  28. SQL query with avg and group by
  29. Optimistic locking in MySQL
  30. Insert and set value with max()+1 problems

Leave a Comment