Skip to content

Instantly share code, notes, and snippets.

@kouk

kouk/select-where-no-primary-key.sql

Created October 23, 2020 11:54
Show Gist options
  • Save kouk/284b12c9e8fa7b4cb270e643319a0439 to your computer and use it in GitHub Desktop.
Save kouk/284b12c9e8fa7b4cb270e643319a0439 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
select-where-no-primary-key.sql
SET @COLS = '';
SELECT GROUP_CONCAT( COLUMN_NAME SEPARATOR ',')
INTO @COLS
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_KEY != 'PRI'
AND TABLE_NAME='mytable'
AND TABLE_SCHEMA = 'mydatabase';
SET @SQL = CONCAT('SELECT ', @COLS, ' FROM mytable');
PREPARE stmt FROM @SQL;
EXECUTE stmt;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment