sequence(max,1)
例题
load data ------控制文件标识
infile 'st.txt' ------要输入的数据文件名
append into table MOBILE_TYPE ------向表中追加记录
fields terminated by ',' ------字段终止于‘,’
TRAILING NULLCOLS ------允许空字段
(TYPE_ID sequence(MAX,1), //sequence
BRAND_ID,
TYPE_NAME,
TYPE_HEIGHT,
PHOSYS_ID)