选择除mysql中仅一个字段外的所有字段[重复]

你可以很容易做到

假设您的字段是id = 5

然后

   select * from your_table where id !=5

如果你的意思是列

假设您不想选择

column3

然后

   select column1,column2,column4 from tablename;

如果您有很多列

    SET @sql = CONCAt('SELECt ', (SELECT REPLACE(GROUP_CONCAt(COLUMN_NAME),  '<columns_to_delete>,', '')     FROM INFORMATION_SCHEMA.COLUMNS WHERe TABLE_NAME = '<table>'   AND TABLE_SCHEMA = '<database>'), ' FROM <table>');    PREPARE stmt1 FROM @sql;   EXECUTE stmt1;