Q. A FULLTEXT index can be created for multiple columns.

  • (A) False
  • (B) True
  • (C) ---
  • (D) ---
💬 Discuss
✅ Correct Answer: (B) True
Explanation: In MySQL, a full-text search is based on the FULLTEXT indexes. A FULLTEXT index can be created both for a single column and for multiple columns. Searching is possible across columns.

Published by Nitin Gupta ⭐ 1.72K Points at 16-Sep-2022 09:32 am in MySQL

Explanation by: Nitin Gupta
In MySQL, a full-text search is based on the FULLTEXT indexes. A FULLTEXT index can be created both for a single column and for multiple columns. Searching is possible across columns.

💬 Discussion

📊 Question Analytics

👁️
234
Total Visits
📽️
4 y ago
Published
🎖️
Nitin Gupta
Publisher
📈
95%
Success Rate