Creates one
INDEX
with several fields for table
notes
. Combines the two fields
title, description
to create one index
CREATE TABLE note (
    id int AUTO_INCREMENT,
    note_id int,
    title varchar(50),
    description varchar(50),
    PRIMARY KEY(id, note_id),
    INDEX ind_title_description (title, description)
);
If we need to filter the result with both fields
(title, description)
at the same time, then
ind_title_description
is a great index
by Valeri Tandilashvili
4 years ago
MySQL
Index
CREATE TABLE
Full MySQL Course for Beginners
1
Pro tip: use ```triple backticks around text``` to write in code fences