MySQL select that returns a dummy column?

Use for a column with empty string

Select column1, column2, '' as dummy_col, column 4 
  from your_table

or for a column with a Null value

Select column1, column2, Null as dummy_col, column 4 
  from your_table

Select column1, column2, 'waiting for table' as dummy_column, column4
from your_table

mysql> SELECT '' AS empty_col;
+-----------+
| empty_col |
+-----------+
|           |
+-----------+
1 row in set (0.00 sec)

Related