TA貢獻(xiàn)1712條經(jīng)驗(yàn) 獲得超3個(gè)贊
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貢獻(xiàn)1818條經(jīng)驗(yàn) 獲得超3個(gè)贊
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貢獻(xiàn)1878條經(jīng)驗(yàn) 獲得超4個(gè)贊
CREATE VIEW vwTableas SELECT col1 , col2 , col3 , col.. , col53 FROM table
舉報(bào)