建表的sql语句:
CREATE TABLE Table123(
T_ID INT,
//T_ID serial, //设置为自增长类型
T_NUMERIC NUMERIC(10,5),
T_DATE DATA,
T_TIMESTAMP TIMESTAMP,
T_VARCHAR VARCHAR(20),
T_CHAR CHAR(20),
T_CLOB CLOB,
T_TEXT TEXT,
T_BLOB BLOB,
T_XML XML,
T_REAL REAL,
T_BIT BIT(2000),
T_BOOL BOOL,
PRIMARY KEY (T_ID) //设置主键
);
然后再insert into 几条数据进去,查看主键列就是自增长的.