Best way to add a column in mysql query

Can any one please let me know that, I need to add a column dynamically when executing mysql query

Table: Table1
--------------------------
col1      col2       col3
--------------------------
Test      OK       Test3
Test      OK       Test5
Test      OK       Test6

from the above example i need to introduce "col2" as new column and its value to be as "OK"

This question and answers originated from www.stackoverflow.com
Question by (5/14/2010 11:15:52 AM)

Answer

select a constant value and give it an alias.

SELECT `col1`, 'OK' AS `col2`, `col3`
FROM `table1`

but why do you need to do this in mysql? if the value is the same for every row, you can just as easy add it in your client (php or similar) code

Answer by
Find More Answers
Related Topics  mysql  query
Related Questions