SELECT 식 FROM 테이블명
mysql> select * from users_frips;
+-----+---------+---------+
| id | frip_id | user_id |
+-----+---------+---------+
| 1 | 26 | 1 |
| 2 | 37 | 1 |
| 3 | 63 | 1 |
| 4 | 73 | 1 |
| 5 | 82 | 1 |
| 6 | 94 | 1 |
| 7 | 96 | 1 |
| 8 | 104 | 1 |
•
•
•
| 325 | 185 | 15 |
| 326 | 192 | 15 |
| 327 | 209 | 15 |
| 328 | 215 | 15 |
| 329 | 226 | 15 |
| 330 | 233 | 15 |
| 331 | 15 | 16 |
| 333 | 19 | 16 |
+-----+---------+---------+
위와 같은 테이블이 있을 때 연산하기
mysql> select frip_id*user_id from users_frips;
+-----------------+
| frip_id*user_id |
+-----------------+
| 26 |
| 37 |
| 63 |
| 73 |
| 82 |
| 94 |
| 96 |
| 104 |
•
•
•
| 2775 |
| 2880 |
| 3135 |
| 3225 |
| 3390 |
| 3495 |
| 240 |
| 304 |
+-----------------+
mysql> frip_id*user_id, frip_id+user_id from users_frips;
+-----------------+-----------------+
| frip_id*user_id | frip_id+user_id |
+-----------------+-----------------+
| 26 | 27 |
| 37 | 38 |
| 63 | 64 |
| 73 | 74 |
| 82 | 83 |
| 94 | 95 |
| 96 | 97 |
| 104 | 105 |
•
•
•
| 2775 | 200 |
| 2880 | 207 |
| 3135 | 224 |
| 3225 | 230 |
| 3390 | 241 |
| 3495 | 248 |
| 240 | 31 |
| 304 | 35 |
+-----------------+-----------------+
SELECT 식 AS 별명 FROM 테이블
mysql> select frip_id*user_id as amount from users_frips;
+--------+
| amount |
+--------+
| 26 |
| 37 |
| 63 |
| 73 |
| 82 |
| 94 |
| 96 |
| 104 |
•
•
•
| 2775 |
| 2880 |
| 3135 |
| 3225 |
| 3390 |
| 3495 |
| 240 |
| 304 |
+--------+