DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a , b ) ENGINE= ; SHOW CREATE TABLE t1; SHOW COLUMNS IN t1; INSERT INTO t1 VALUES (1,'a'); INSERT INTO t1 (a,b) VALUES (2,'b'); SELECT a,b FROM t1; a b 1 a 2 b DROP TABLE t1;