add a temporary column with a value

Question

I have a select statement like this  select field1  field2     from table1   What I want is to have a newfield with only value  example    newfield does not exist in the table  but when I run this query it kinda makes a virtual column with the values of example field

User · Answer

I m rusty on SQL but I think you could use select as to make your own temporary query columns   select field1  field2   example  as newfield from table1   That would only exist in your query results  of course  You re not actually modifying the table

User · Answer

I giving you an example in wich the TABLE registrofaena doesn t have the column called minutos  Minutos is created and it content is a result of divide demora 60  in other words  i created a column to show the values of the delay in minutes   This is the query   SELECT idfaena fechahora demora  demora 60 as minutos comentario  FROM registrofaena   WHERE fecha gt   2018-10-17  AND comentario  lt  gt      ORDER BY idfaena ASC    This is the view

User · Answer

You mean staticly define a value  like this   SELECT field1          field2          example  AS newfield   FROM TABLE1   This will add a column called  newfield  to the output  and its value will always be  example

User · Answer

select field1  field2  NewField    example  from table1

User · Answer

select field1  field2   example  as TempField from table1   This should work across different SQL implementations

User · Answer

select field1  field2     as newfield from table1   This Will Do you Job

[sql] add a temporary column with a value

Examples related to sql

Examples related to mysql