表Temp
+------+-------+
| id | value |
+------+-------+
| 1 | 111 |
| 2 | 222 |
| 3 | 333 |
+------+-------+比如这样的表,我要查询出这样的结果
+------+-------+-------+
| id | value | A |
+------+-------+-------+
| 1 | 111 | 2 |
| 2 | 222 | 2 |
| 3 | 333 | 2 |
+------+-------+-------+
就是说新增加一列,这列的值是2
如何查询?
+------+-------+
| id | value |
+------+-------+
| 1 | 111 |
| 2 | 222 |
| 3 | 333 |
+------+-------+比如这样的表,我要查询出这样的结果
+------+-------+-------+
| id | value | A |
+------+-------+-------+
| 1 | 111 | 2 |
| 2 | 222 | 2 |
| 3 | 333 | 2 |
+------+-------+-------+
就是说新增加一列,这列的值是2
如何查询?
from temp;