Teknooke.com Kumpulan Informasi Teknologi
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
