CODEWITHSUNDEEP
mysqlsqlstringselect
Dorshin
Dorshin

Reputation: 135

MySQL SELECT with an extra column containing a string

I used to know how to do this, but I can’t seem to remember or find the answer.

I want to return data from a table and then just add an extra column with a set value (which does not need to be saved). So, it is not an UPDATE issue. Just a SELECT with that extra column.

Original table:

|  id  |   col1   |   col2   |
|  1   |  value1  |  value2  |

Return something like this:

|  id  |   col1   |   col2   ||    tmpCol    |
|  1   |  value1  |  value2  ||    12:48     |

Upvotes: 0

Views: 824

Answers (3)

user3624755
user3624755

Reputation: 51

try this. alter table TableName add column columnName date ; note, put the exact table name in the "TableName that i defined" that u want to add the column and put the column name where i defined the "columnName"

Upvotes: 0

ashishmaurya
ashishmaurya

Reputation: 1196

use this

select id,col1,col2, '12.48'  as tempcol

Upvotes: 0

Marc B
Marc B

Reputation: 360602

It's as simple as:

SELECT id, col1, col2, '12:48' AS tempCol

Upvotes: 3

Related Questions