How can a query multiply 2 cell for each row MySQL?

by

Use this:

SELECT 
    Pieces, Price, 
    Pieces * Price as 'Total' 
FROM myTable

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. Create a Cumulative Sum Column in MySQL
  3. MySQL: Enable LOAD DATA LOCAL INFILE
  4. Equivalent of explode() to work with strings in MySQL
  5. mysql select dynamic row values as column names, another column as value
  6. Access denied for user ‘root’@’localhost’ (using password: YES) (Mysql::Error)
  7. MySQL root access from all hosts
  8. Setting up MySQL and importing dump within Dockerfile
  9. How to import data from text file to mysql database
  10. Select last N rows from MySQL
  11. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  12. Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT clause?
  13. Simple Random Samples from a Sql database
  14. How to select date from datetime column?
  15. node.js mysql error: ECONNREFUSED
  16. How do I use properly CASE..WHEN in MySQL
  17. Delete query not working in mysql
  18. Not unique table/alias
  19. SQL Server equivalent of substring_index function in MySQL
  20. Remote connect to clearDB heroku database
  21. MySQL foreign key to allow NULL?
  22. MySQL : When stored procedure parameter name is the same as table column name
  23. Does a UNIQUE constraint automatically create an INDEX on the field(s)?
  24. MySQL 5.0 indexes – Unique vs Non Unique
  25. MySQL – Select from a list of numbers those without a counterpart in the id field of a table
  26. MySql – How get value in previous row and value in next row? [duplicate]
  27. Updating table in trigger after update on the same table
  28. Autostart MySQL Server on Mac OS X Yosemite/El Capitan
  29. mysql double-quoted table names
  30. MySQL giving “read ECONNRESET” error after idle time on node.js server

Leave a Comment