Select all columns except one in MySQL?,
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;
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.
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