0
# 提换下users, 和test_db即可
SET @sql =  (select CONCAT('SELECT ', (SELECT REPLACE(GROUP_CONCAT(COLUMN_NAME), 'id,', '') FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'users' AND TABLE_SCHEMA = 'test_db'), ' FROM  users'));

PREPARE stmt FROM @sql;
EXECUTE stmt;

Broadcast


JoyK
Better personal homepage
reddit style
GitHub Flavored Markdown syntax
Adaptive layout