1940
1940
fld1 INTEGER FALSE 0 FALSE
1941
1941
companynr INTEGER FALSE 0 FALSE
1946
1946
show columns from t2 from test like 'f%';
1947
1947
Field Type Null Default Default_is_NULL On_Update
1949
1949
fld1 INTEGER FALSE 0 FALSE
1950
1950
companynr INTEGER FALSE 0 FALSE
1955
1955
show columns from t2 from test like 's%';
1956
1956
Field Type Null Default Default_is_NULL On_Update
1958
1958
fld1 INTEGER FALSE 0 FALSE
1959
1959
companynr INTEGER FALSE 0 FALSE
1964
1964
drop table t4, t3, t2, t1;
1966
1966
id bigint NOT NULL auto_increment,