简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW)
Home > Database > Mysql Tutorial > body text

MySQL - Introduction to several ways to add indexes

黄舟
Release： 2017-03-13 13:11:59
Original
1607 people have browsed it

1. Add PRIMARY KEY (primary key index ) 

mysql>ALTER TABLE `table_name` ADD PRIMARY KEY ( `column` )
Copy after login


2. Add UNIQUE (unique index) 

mysql>ALTER TABLE `table_name` ADD UNIQUE ( `column` )
Copy after login


3. Add INDEX (normal index) 

mysql>ALTER TABLE `table_name` ADD INDEX index_name ( `column` )
Copy after login


4. Add FULLTEXT (full-text index) 

mysql>ALTER TABLE `table_name` ADD FULLTEXT ( `column`)
Copy after login


5. Add multi-column index

mysql>ALTER TABLE `table_name` ADD INDEX index_name ( `column1`, `column2`, `column3` )
Copy after login


The above is the detailed content of MySQL - Introduction to several ways to add indexes. For more information, please follow other related articles on the PHP Chinese website!

Related labels：
MySQL，添加索引
source：php.cn
Previous article：MySQL delete database (delete) 2 methods Next article：MySQL - Summary of code examples for basic operations
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Catching Guzzle exceptions I'm trying to catch exceptions in a set of tests running on an API I'm developing, and I'm...
From 2023-11-16 14:36:03
0
12
290
Nuxt.js: window is not defined apexcharts/vue-apexcharts I've added this simple example from apexcharts.com. Pretty sure the import is correct. I d...
From 2023-11-09 22:07:08
0
2
217
Composite full-text index in MySQL I want the system to allow searching user messages by specific users. Suppose I have the f...
From 2023-11-07 18:44:49
0
2
185
Module not found: error: cannot resolve '@heroicons/vue/24/outline' Immediately after adding this reference in my vue component I get the error: <scriptset...
From 2023-11-01 14:45:19
0
1
222
Adding foreign key columns to a MySQL table: step-by-step guide I have a table named payment_request in MySQL DESCRIBEpayment_request giving the following...
From 2023-10-29 18:54:01
0
2
193
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！