MySQL一些查询的解决方法_MySQL

+----+---------+---------+| id | column1 | column2 |+----+---------+---------+|  1 |       1 |       2 ||  2 |       3 |       4 ||  3 |       5 |       6 |+----+---------+---------+

column1 * column2+----+--------+| id | Result |+----+--------+|  1 |      2 ||  2 |     12 ||  3 |     30 |+----+--------+

SELECT id, (column1 * column2) AS Result FROM table;

+----+--------+| id | Result |+----+--------+|  1 | 1 * 2  ||  2 | 3 * 4  ||  3 | 5 * 6  |+----+--------+

SELECT id, CONCAT(column1, ' * ', column2) AS Result  FROM table;