Select all columns except one in MySQL?

Question :

Select all columns except one in MySQL?,

Answer :

I’m trying to use a select statement to get all of the columns from a certain MySQL table except one. Is there a simple way to do this?

EDIT: There are 53 columns in this table (NOT MY DESIGN)

,

Actually there is a way, you need to have permissions of course for doing this …

SET @sql = CONCAT('SELECT ', (SELECT REPLACE(GROUP_CONCAT(COLUMN_NAME), ',', '') FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '' AND TABLE_SCHEMA = ''), ' FROM 
'); PREPARE stmt1 FROM @sql; EXECUTE stmt1;

Replacing

, and

That’s the answer Select all columns except one in MySQL?, Hope this helps those looking for an answer. Then we suggest to do a search for the next question and find the answer only on our site.

Disclaimer :

The answers provided above are only to be used to guide the learning process. The questions above are open-ended questions, meaning that many answers are not fixed as above. I hope this article can be useful, Thank you

Read More  Interfaces on different logic layers