All pastes #806230 Raw Edit

Something

public text v1 · immutable
·published 2007-12-05 01:26 UTC
rendered paste body
CREATE TABLE 	TBL_TEST (
	pk_test 	integer unsigned not null primary key auto_increment,
	int_testvalue1	int,
	int_testvalue2 	int(4)	
);



-------------
output:
-------------
show full fields from tbl_test;

Field		Type	
pk_test		int(10) unsigned
int_testvalue1	int(11)	
int_testvalue2	int(4)