Extract the column names of a table (so you can select many columns but exclude some)


/ Published in: MySQL
Save to your folder(s)

This will get the names of all the columns as one long string ready to use in a select statement. N.B. There is a list of column names to exclude (In this case '???COLUMNS_TO_EXCLUDE???')

URL: http://www.sql-ex.ru/help/select20.php

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.