# 为某字段改属性并创建索引 alter table tlk_attendance_site_person_info modify ITEM_USER_ID varchar(200) not null default '#'; create index index_tlk_attendance_site_person_info_user_id on tlk_attendance_site_person_info(ITEM_USER_ID);