详细内容
创建索引的语法
发布日期:2022-08-24     点击:716     字体:[ ]

1.创建索引语法
create index index_name on table_name(column1);

例如:create index 'idx_quotation_createdByUsername' on quotation("createdByUsername");


2.创建组合索引
create index 'idx_quotation_createdByUsername' on quotation("createdByUsername","createdBy");

3.唯一索引
create unique index 'idx_quotation_createdByUsername' on quotation("createdByUsername","createdBy");

4.删除索引

drop index 'idx_quotation_createdByUsername';

用户评论
昵称 
内容  *
验证码   
   
Copyright © 2010 zdbase.com All Rights Reserved. 苏ICP备15039389号 可人软件设计