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;