steelerman99 Posted February 9, 2008 Share Posted February 9, 2008 Hello, I was wondering if you can modify a SELECT query to return all columns but just one or two. We know that doing " Select * " will display all columns of the table. What if we have say 50 columns, but we only want to exclude one or two columns? Would we have to type " SELECT col1, col2, col3, .......... , col 49, col50 FROM...." or is there an easier way to do this? Thanks!! Quote Link to comment Share on other sites More sharing options...
toplay Posted February 9, 2008 Share Posted February 9, 2008 Would we have to type " SELECT col1, col2, col3, .......... , col 49, col50 FROM...." ? Yes. Specify just the columns you want (data returned). http://dev.mysql.com/doc/refman/5.0/en/select.html Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.