Mysql not select columns

Question

I have a table contain 22 columns

I have a query need to SELECT 20 columns

Is any way to do a query like NOT SELECT (the columns i don't want to select)

So I don't need to type SELECT column1, columns2...

You can hide the fields in a view so you don't need to complicate your query by selecting 20 out of 22 columns. — dcaswell, Aug 27 '13 at 06:36
http://stackoverflow.com/questions/9122/select-all-columns-except-one-in-mysql — Praveen Prasannan, Aug 27 '13 at 06:44

score 2 · Answer 1 · answered Aug 27 '13 at 06:36

2

You cannot do it as you expected. You have to type all the columns you want. If you have run the query many times, you can create a VIEW with selected columns.

answered Aug 27 '13 at 06:36

DB_learner

1,026
9
15

score 1 · Answer 2 · answered Aug 27 '13 at 06:37

1

The only way is to specify the columns you want or use the '*' wildcard

SELECT * FROM TABLE

or

SELECT column1, column2...

answered Aug 27 '13 at 06:37

Sal00m

2,938
3
22
33

score 1 · Answer 3 · answered Aug 27 '13 at 06:38

1

SQL doesn't allow to hide some columns. You can either select all columns by using SELECT * ... or list columns you need by SELECT col1, col2, ...

answered Aug 27 '13 at 06:38

Maksym Polshcha

18,030
8
52
77

score 1 · Answer 4 · edited May 23 '17 at 11:49

1

Please check this answer. It is the only way to do that

Select all columns except one in MySQL?

(I can't comment so I put the link as an answer)

Cheers

edited May 23 '17 at 11:49

Community

1
1

answered Aug 27 '13 at 06:39

jpruizs

485
1
5
19

score 1 · Accepted Answer · answered Aug 27 '13 at 06:39

1

No it is not possible, the expression "select all except" or "NOT SELECT" has not yet been implemented in any existing database.

answered Aug 27 '13 at 06:39

Roy M J

6,926
7
51
78

Mysql not select columns

5 Answers5