Mysql tip: How to SELECT all the columns by name

Thanks to this stackoverflow answer
Here’s how you can create a SELECT all columns (except one) sql:

SET @sql = CONCAT('SELECT '
, (SELECT REPLACE(GROUP_CONCAT(COLUMN_NAME), '<columns_to_omit>,', '')
   FROM INFORMATION_SCHEMA.COLUMNS
   WHERE TABLE_NAME = '<table>'
   AND TABLE_SCHEMA = '<database>'), ' FROM <table>');

And thanks to this stackoverfow answer

Here’s how to print that statement


select @sql;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: