MySQL: add element to result array

Question

Is there any way I can add an integer to each entry in the result array returned from an SQL query?

For example a query like:

SELECT * FROM mytable

Is there anything I can add to that statement to add a column to the resulting array with a specified integer in it?

Thanks, does newCol need to be added as a column in the table? — Lukesmith
– Lukesmith, Commented May 30, 2015 at 14:57
No you don't need to add a new column to your table that's just an alias ;). — shA.t
– shA.t, Commented May 30, 2015 at 14:59

shA.t · Accepted Answer · 2015-05-31 03:03:24Z

1

Try something like this:

SELECT *, 1 AS newCol 
FROM mytable

You can also set your specific type of your field by using CAST like this:

SELECT *, CAST(1 AS DECIMAL(4,2)) As newCol
FROM mytable

answered May 30, 2015 at 15:00

shA.t

17.1k5 gold badges59 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1