MySQL - Excluding Rows From SELECT

Asked Jul 18 '17 at 12:01

Active Jul 18 '17 at 12:01

Viewed 38 times

I have been given a Table with ~50 columns. Obviously I could select them all with:-

SELECT * FROM...

However for confidentiality three columns must not be selected. Many of the columns use long identifiers. Is there a way of selecting all columns by excluding nominated ones rather than selecting all ~47?

asked Jul 18 '17 at 12:01

MichaelJohn

2

Use views which selects only required fields and in application do select * from view – Akhil Jul 18 '17 at 12:03
duplicate - https://stackoverflow.com/questions/9122/select-all-columns-except-one-in-mysql – Manoj-kr Jul 18 '17 at 12:07

MySQL - Excluding Rows From SELECT

0 Answers0