×
Night mode
Sign up
Login
Create INDEX with several fields
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
5 years ago
MySQL
Index
CREATE TABLE
Full MySQL Course for Beginners
1
Pro tip: use ```triple backticks around text``` to write in code fences