On 09/12/05, Frank Rust <[EMAIL PROTECTED]> wrote: > Is there a possibility to select all columns from a table except one or > two columns? For example I have a table with 30 columns and want all > columns but one column *not*. Do I have to write a very long select > statement with 29 column names that i want to get?
If you're using MySQL 5.0 an up you could achieve similar functionality using views. http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-views.html Will. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
