TA貢獻1712條經驗 獲得超3個贊
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>');PREPARE stmt1 FROM @sql;EXECUTE stmt1;<table>, <database> and <columns_to_omit>
TA貢獻1818條經驗 獲得超3個贊
col1, ..., col100
mysql> CREATE TEMPORARY TABLE temp_tb SELECT * FROM orig_tb;mysql> ALTER TABLE temp_tb DROP col_x;mysql> SELECT * FROM temp_tb;
TA貢獻1878條經驗 獲得超4個贊
CREATE VIEW vwTableas SELECT col1 , col2 , col3 , col.. , col53 FROM table
舉報