索引表中的mysql更新查询

问题描述

我的一张表有主键组合，我都为该表做了索引。



EX：TableName - > StudentMark



Primay Key - > ClassName，RollNo（两者都是我设定的索引）





现在我在做查询



更新StudentMark set name =''XXX''其中ClassName =X且RollNo = 1



更新StudentMark set name =''XXX ''其中RollNo = 1且ClassName =X



查询是否合适。因为我做了索引类名，rollno。

One of my table having combintaion of primary key, both i did index for that table.

EX: TableName -> StudentMark

Primay Key -> ClassName, RollNo (Both are i set index)


Now i am doing the query

Update StudentMark set name =''XXX'' where ClassName ="X" and RollNo = 1

Update StudentMark set name =''XXX'' where RollNo = 1 and ClassName ="X"

which query is proper. because i did the index classname, rollno.

推荐答案

这篇关于索引表中的mysql更新查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！