以下几条语句查询时经常用到,要怎么加索引或者给哪些字段加索引会加快查找。谢谢
SELECT
FROM Cmdt
WHERE IS_PATIENT = 0
AND (
STATUS = 'SCHEDULED'
OR STATUS = 'AWAITING'
)
AND END_DATE > NOW()
SELECT
FROM Cmdt
WHERE IS_PATIENT = 0
AND STATUS = 'SCHEDULED'
AND END_DATE > NOW()
SELECT
FROM C_mdt
WHERE STATUS = 'SCHEDULED'
AND RESERVATION_ID = '66'
SELECT
FROM Cmdt
WHERE IS_PATIENT = 0
AND (
STATUS = 'SCHEDULED'
OR STATUS = 'AWAITING'
)
AND END_DATE > NOW()
SELECT
FROM Cmdt
WHERE IS_PATIENT = 0
AND STATUS = 'SCHEDULED'
AND END_DATE > NOW()
SELECT
FROM C_mdt
WHERE STATUS = 'SCHEDULED'
AND RESERVATION_ID = '66'
解决方案 »
- 新手请教,mysql创建触发器语法错误
- mysql 命令连接远程数据库
- 在线求解
- 换数据库用phpmyadmin导入.sql文件出现“有可能您发现了SQL分析器的臭虫。”
- is not allowed to connect to this MySQL server 问题??
- 刚安装了个5.0版的mysql数据库,怎么就连接不上呢???
- 求助,同一个表,cid相同,比较字段的查询语句
- 一个初学者的小问题,不过很急用
- 简单问题:mysql一张表中最多可以存放多少条数据
- mysql自定义函数返回乱码问题
- MYSQL 如何修改时区
- character-set-server 在配置文件修改后,查询字符依然显示latin1
IS_PATIENT ,status, END_DATE
STATUS ,RESERVATION_ID