MySQL - Indexes
An index is a performance-tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed columns.
CREATE INDEX [index name] ON [table name]([column name]);
CREATE INDEX StudentID ON studentrecord(StudentID);
Index gets created as we check indexes in the respective table.In Case it is not visible please refresh the object explorer so that you can see the created INDEX.
CREATE UNIQUE INDEX newStudentID ON studentrecord(StudentID);
As a result,UNIQUE INDEX gets created.
MySQL - Triggers
posted on 2019-11-29 21:44:07 - mysql Tutorials
MySQL - Grant_ Revoke Privilege
posted on 2019-11-26 23:15:04 - mysql Tutorials
MySQL Vs SQL
posted on 2019-11-25 05:02:26 - mysql Tutorials
how to use range in golang
posted on 2022-05-03 08:28:11 - Go lang Tutorials
find variable type in golang
posted on 2022-05-03 05:24:55 - Go lang Tutorials
for loops in golang
posted on 2022-05-03 04:27:40 - Go lang Tutorials