select all the fields (exclude a few fields) from a table.

[eluser]searain[/eluser]
20 fields is just a fictional number, I do have a few tables have 20 fields, but most of them are less. It just naturally has these fields in and I don't have too many records to deal with. From hundreds records to no more than 2,000 records each table etc.

The reason that I try to exclude a few fields for the select *, is not for the typing reason either (not for the performance reason too )

But more likely for a framework I am designing. It is based on CodeIgniter. I have my framework's database set up, CRUD is done etc. And if a new field added, I just need add a new field in that table's structure in the database. The rest CRUD php scripts etc are all taken care of. I don't have to go to my system to change any CRUD script. The new added fields will be automatically show in the system.

But if I have to name each field I want to select, then I have to go to my system and recode some CRUD script, when I add a new field to or remove a field from a table.