Question

页: 1

+-----+------------------+-------------+
| id  | datenum          | F1_baro_20_ |
+-----+------------------+-------------+
|   1 | 734152.000000000 |     1005.21 |
|   2 | 734152.006944445 |     1005.26 |
+-----+------------------+-------------+

When I make a selection I want to add one more column.

例如

SELECT id,datenum, F1_baro_20_ FROM test

我想增加一栏,例如:

SELECT id,datenum, F1_baro_20_, new_column=1 FROM test

+-----+------------------+-------------+------------+
| id  | datenum          | F1_baro_20_ |new_column  |
+-----+------------------+-------------+------------+
|   1 | 734152.000000000 |     1005.21 |       1    |
|   2 | 734152.006944445 |     1005.26 |       1    |
+-----+------------------+-------------+------------+

Answer 1

SELECT id, datenum, F1_baro_20_, 1 AS new_column FROM test;

这甚至有更为复杂的表述:

SELECT id, datenum, F1_baro_20_, (IF id = 2 THEN 1 ELSE 0) AS id_is_two FROM test;

友情链接