filmov
tv
MySQL : Create new index on table
Показать описание
So in this tutorial video you are going to learn how to create a new index on table , anyhow to show index .
steps :
first thing you have to use database , next show tables and describe table .
2- too create index : create index "type index name " on "type table name" (select value)" ;
example : create index index1 on tabel1(id);
example2: create index index1 on table2(id, name);
exampel3: create index index1 on table2(id, name,address);
steps :
first thing you have to use database , next show tables and describe table .
2- too create index : create index "type index name " on "type table name" (select value)" ;
example : create index index1 on tabel1(id);
example2: create index index1 on table2(id, name);
exampel3: create index index1 on table2(id, name,address);