实际上有一种方法，您当然需要具有执行此操作的权限…
SET @sql = CONCAt('SELECt ', (SELECT REPLACE(GROUP_CONCAt(COLUMN_NAME), '<columns_to_omit>,', '') FROM INFORMATION_SCHEMA.COLUMNS WHERe TABLE_NAME = '<table>' AND TABLE_SCHEMA = '<database>'), ' FROM <table>');PREPARE stmt1 FROM @sql;EXECUTE stmt1;更换
<table>, <database> and <columns_to_omit>
