MYSQL "SELECT *:not(id) FROM...". Is there something similar?

Question

When I JOINing to tables which both have 'id' column, I getting the result with 'id' not from the table I need. And both these table has a lot of columns so I don't want to type them all in my query. Is it posible to do something similar to css :not like SELECT table1.*, table2.*:not(id) FROM ...? Or maybe there is some other solution?

Thanks

Many people probably long for this, but almost everyone will tell you that it is better practice to always list out all the columns you wish to return so you do not have to change every select/function/procedure if you make a schema update. — DrCopyPaste, May 02 '13 at 14:56

score 4 · Answer 1 · answered May 02 '13 at 14:55

4

If you do not want a particular column from a table, then you cannot use the *, you have to type out all of the columns that you want to get.

answered May 02 '13 at 14:55

Naftali

144,921
39
244
303

2

Which one should probably do anyway, to ensure that a new column added to the table or view (or a reordering of existing columns) doesn't break the application. – cdhowie May 02 '13 at 14:56

score -1 · Answer 2 · answered May 02 '13 at 14:57

-1

That select will be returning both id columns; it's your programming language's libraries that are presumably only giving you access to one.

That said, does

SELECT table2.*, table1.* ...

get you all the columns you need?

answered May 02 '13 at 14:57

ysth

96,171
6
121
214

score -2 · Answer 3 · answered May 02 '13 at 15:16

-2

I found a solution myself. Very simple. I just replaced my second table to the first place and first table now goes after JOIN. Seems mysql returns only the ID of the latest table.

Thanks everyone!

answered May 02 '13 at 15:16

artnikpro

5,487
4
38
40

No. That's your application level code that's doing that – Strawberry May 02 '13 at 15:33

MYSQL "SELECT *:not(id) FROM...". Is there something similar?

3 Answers3