MySQL : Create new index on table

preview_player
Показать описание
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);
Рекомендации по теме