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
What Is Oracle
posted on 2019-11-29 01:11:21 - ORACLE Tutorials
ORACLE - Trigger
posted on 2019-11-28 22:14:22 - ORACLE Tutorials
ORACLE - Cursor
posted on 2019-11-28 22:13:54 - ORACLE Tutorials