Select something + arbitrary number in Mysql

Question

I have a situation where I need to do something like

select 2, id from users;

I think this works at least with Oracle, but it doesn't work in Mysql. Any ideas?

0

lhahne 05 May '09 @ 9:21

2 answers

your request is ok. You may have pinpointed "Doesn't work".

0

Antoine claval 05 May '09 at 9:25

BrynJ · Accepted Answer · 2009-05-05T09:25:49+0000

I think you need to assign a name to your arbitrary value:

SELECT 2 AS arbitrary_value, id FROM users;